Forum home » Delegate support and help forum » Microsoft Access Training and help » access+course+training - Statistical Queries
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access+course+training - Statistical Queries
Resolved · Low Priority · Version Standard
Reply Sat 25 Aug 2007, 22:51Delegate Judith said...
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!)
For upcoming training course dates see: Pricing & availability
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
Reply Thu 20 Sep 2007, 01:08Delegate Judith said...
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!
|