How do I count specific numbers in an Access 2003 database table?

5 pts.
Tags:
Access Database
Microsoft Access 2003
Microsoft Access database
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

Create a query with this code (SQL):

<pre>SELECT your_field, COUNT(*)
FROM your_table
GROUP BY your_field</pre>

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jblake
    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.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following