Forum home » Delegate support and help forum » Microsoft Access Training and help » access courses in london - Count 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 courses in london - Count queries
Resolved · Low Priority · Version Standard
Reply Mon 4 Jun 2007, 16:24Delegate Jonathan said...
Jonathan has attended:
Access Intermediate course
Count queries
I am familiar with COUNT queries, but I wondered if it was possible to COUNT within categories or ranges of values.
For example, I have 100 orders each of different amounts between
For upcoming training course dates see: Pricing & availability
RE: Count queries
Jonothan,
You might need to do 3 separate queries until you find a better way. Create a basic query that has criteria on the AMOUNT field, and specify your range. Once this step is done, you can then count the number of records.
You could Also use a SQL statement like this:
You need to do a query where you use the Group By statement something like follows:
SELECT tblYourTable.Question1Answer, Count(tblYourTable.Question1Answer) AS MyCount
FROM tblYourTable
GROUP BY tblYourTable.Question1Answer
ORDER BY tblYourTable.Question1Answer;
tblYourTable = The name of your table.
Question1Answer = The name of the field with your answers in it.
This is one of the most powerful SQL abilities of course, but a lot of people forget that you can put a count() of in the SELECT statement to get the number of occurrences.
|