Qualification > Sciences

help in access

(1/3) > >>

MissDE:

I need help in Access!!!!!!!!!!!!

I don't understand the count and sum,
especially when the question asks about EACH record!!!!


I just have few hours left, i need help very quickly!

sweetsh:
Post a specific question from any past paper and Ill answer

MissDE:
I really appreciate ur respond! :D

here is the question:

Produce a new report from all the data which:
• shows a summary of only the Code and Potential Area fields
• performs a count of the number of sites in each Code
• calculates the sum of the Potential Area within each code

Waiting... ::)

sweetsh:
Oh god :D
You couldnt find any question except the summary one!  8)
I'm not at it at all..And I did it in such a way in the exam..What I know you should do in one of the steps..
That while doing the Query ...using a wizard ofcourse..use the 1st query not the table...thats what one of the teachers said,,,then click next.."Summary" and do what you are told...note that not everything will be done from here...finish
when you go to  the disign view of the query you made..click on the "Totals" icon that looks like an "E"
and a new row will appear "Group By" and you choose the criteria...Till here I can do things but after this im not good at all...I hope someone comes and tell you the rest..

Any other question in ICT please ask (without the summary thing :P)
Good luck

SGVaibhav:
ok i will continue from where sweetsh stopped.

ok i dont know the exact question.
but i will tell the general things to be done in this query.


* shows a summary of only the Code and Potential Area fieldsAfter that new row appears.
for code , u can select group by     (do not select group by for potential area, because we want its sum so leave it intact)


performs a count of the number of sites in each Code

put sites as a new column
in that new row, select "Count", this will count the number of sites.



• calculates the sum of the Potential Area within each code
in the potential area column, select sum.

i think ur done!

Navigation

[0] Message Index

[#] Next page