98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » access+course+training - Statistical Queries
access+course+training - Statistical Queries
Resolved · Low Priority · Version Standard
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!)
Thu 13 Sep 2007, 16:08Trainer David said...
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
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!
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 tip:Change caseTo change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3 |
