Home > IT Answers > Database > How do I count specific numbers in an Access 2003 database table?
Cgarbeads
5 pts.
 How do I count specific numbers in an Access 2003 database table?
Access 2003, Access Database, Access Database Design, Access Database Filters
I have over 6700 numbers in one field. No other fields in database. I want to find out how many times there is a number 1, 2, 3, 4, etc. in this list of possible numbers. I am not proficient in Access like you all are and am lost on creating a report with the results of this data. I appreciate any help you can pass on.

Software/Hardware used:
Microsoft Access 2003
ASKED: November 4, 2010  2:16 PM
UPDATED: November 18, 2010  3:19 PM
RELATED QUESTIONS
Answer Wiki:
Create a query with this code (SQL): <pre>SELECT your_field, COUNT(*) FROM your_table GROUP BY your_field</pre>
Last Wiki Answer Submitted:  November 4, 2010  3:37 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You can also use a crosstab query (query-wizard-crosstab) where the row is the number and summary field is the count of the number. You will have to pick a column. I don’t know how to eliminate this in an access query. But it will give you what you need and you can create a report from it.

Jblake
 10 pts.