Judith has attended:
Access Intermediate course
Access Advanced course
Statistical Queries
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!)
RE: Statistical Queries
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
RE: Statistical Queries
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!
