URGENT ICT HELP!! exam on 19th!!

[JD46]

45) Produce a new report from all the data which:
• shows a summary of only the Country, Product and Stock fields
• performs a count of the number of Products for each Country
• calculates the sum of the number of items in Stock for each Country
• only reports where Products number more than 3

How do i do the second one as when i click on count of j7stock(or whatever)in 2003 access its gives me '1s' intead of adding all the '1s' together for each country!

Moderators please don't delete this as no one is responding in the ICT thread for help so i might as well try my luck outside the thread,considering that i have my boards on monday,i hope you understand the urgency of my doubts! Thanks

[holtadit]

Most of the guys who do ICT are currently offline.

Hang in there !!

[Amr Fouad]

Do not Double post..This is a warning

[JD46]

A.F
Sorry ,i did post before but i couldnt see my post amongst the list! so i thought may be i didnt do it right so i posted again,no offence intended!

[Amr Fouad]

Then we are clear then 

[Nobody]

Most of the guys who do ICT are currently offline.

Hang in there !!

okay..people...Nobody is the ICT master.....
I am nobody..
=====
1. shows a summary of only the Country, Product and Stock fields
2. performs a count of the number of Products for each Country
3. calculates the sum of the number of items in Stock for each Country
4. only reports where Products number more than 3

Answers......

First do the 4^th step..In criteria (while you do Query) add
">3"
1^th step Do the query, when you are doing the query, you take only these fields Country, Product and Stock and also you don't select the DETAIL option...you select summery option!
2^nd & 3^rd step you will see an option to calculate sum of a field and also in the bottom right corner of that table, you will see an option "Count records in TABLE NAME"

[Nobody]

tell me if you don't get it or need print shots of these questions!....Happy to Help!!

[ksitna]

yeah can i have printshots

thank you

[Nobody]

Tell me what paper is this?
I'll do it and post screen shots soon!!!!!

[ksitna]

june 08 paper 2
question 45

the same one ur talking about

[ksitna]

thing is i keep getting 1s for the count
i dont get it 

[JD46]

I  GOT IT!!!

1)i used to get 1's before but you gotta, make a noraml query with  wizard,then  you gotta click on the total button(looks like a weird kinda E)a row will appear there u gotta leave country as 'group by' and change the other 2 to sum and count(what eva u is required),checked with the MS ,its right!

Thanks nobody and the others for being so supportive and helpful,you guys kept my spirits up!

[~HyDrOgEn~]

I did not post anything.
Please forgive me.

[Saladin]

Please do not ask for any information regarding the ICT practical, or else you will get permanently banned.

[JD46]

49)Using a lookup function replace the initials for each member of Staff with their Full
name using the file N7STAFF.CSV  -ON07(october/November)

Staff   Sum Of Sales   Count Of N7STOCK
CP   414                          16
CS   26                           7
IS   197                          25
KP   205                          10
PO   115                           7
RT   236                          12

How do i do this!? ,vlookup isn't working somehow!!