Qualification > Miscellaneous

URGENT ICT HELP!! exam on 19th!!

(1/4) > >>

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! :D

Amr Fouad:
Then we are clear then  :D

Navigation

[0] Message Index

[#] Next page