Qualification > Miscellaneous

URGENT ICT HELP!! exam on 19th!!

<< < (2/4) > >>

Nobody:

--- Quote from: Ari Ben Canaan on April 17, 2010, 06:01:52 am ---Most of the guys who do ICT are currently offline.

Hang in there !!

--- End quote ---

okay..people...Nobody is the ICT master.....
I am nobody.. :P
=====
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 4th step..In criteria (while you do Query) add
">3"
1th 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!
2nd & 3rd 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

Navigation

[0] Message Index

[#] Next page

[*] Previous page