IGCSE/GCSE/O & A Level/IB/University Student Forum
Qualification => Subject Doubts => IGCSE/ GCSE => Sciences => Topic started by: MissDE on April 25, 2009, 08:33:48 pm
-
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!
-
Post a specific question from any past paper and Ill answer
-
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... ::)
-
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
-
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 fields
After 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!
-
Guess What!
This is funny!
I knw all thse steps,
but i dnt knw what to do next!
Ok I'll keep trying,
Thank u anyway Sweetsh :D
-
OK good, sgvaibhav !
I'll be waiting. :D
-
thank you sgvaibhav :) and you welcome DE
-
Ok sgvaibhav ,
I have to go now, pls try to post the answer so that i can knw
it b4 the exam, which is after 8 hrs !!!
(ok i knw im very annoying bt i really need the steps ::) )
and thank u again sweetsh!
-
We all wish you and everybody else a good luck
-
i wrote the answer b4 9mins b4 u posted that!
Ok sgvaibhav ,
I have to go now, pls try to post the answer so that i can knw
it b4 the exam, which is after 8 hrs !!!
(ok i knw im very annoying bt i really need the steps Roll Eyes )
and thank u again sweetsh!
-
i do it like this
go to the place where u make the Queries,,
1) choose creat Query by wizard
2) in the selected field add the fiels required by the Question ( code and potential area here ) then click next
3) then choose Summary and then summary options
4) tick mark the box under the SUM and also mark the option at the bottom right side ( below ok and those ) then click ok
5) click next and then add a name and then finish
you are DONE
-
Sorry sgvaibhav, that time i just wanted to sleep...! :D
and
thank u everybody this is great and i'm very thankful!
I'm now going to the exam,
wish me the good luck....... ::)