I am just starting to create queries to pull statistics from a database. I have tried using "count" but that just counts all the entries, I can create a report which lists the different entries but not the total of each. e.g. How many F and how many M (Thats the simple one!)

Hi Judith

To do this you will need to use the count function but also add on a where clause. So you count all enteries where the field is equal to F and then do the same for M.

This should work.

Hope this helps
David

Thank you.

This is OK for simple M and F but when you start trying to pull Ethnicity Codes (of which there are about 10) and Disability Codes (about 7) this is going to be a very laborious process. In fact my current proceedure which is to run a filter and then count the records by hand, is probably about the same. Is there any way I can change the way this information is recorded which would allow me to run one query which will return X number of Code 1s and X number of Code 2s etc? With organisations running these kind of statistical information queries every day I am sure someone must have solved this one!