Count repeats

[RobertM]

I know this is a simple query, but I can't remember how to do it. I need to
count how many times each value repeats in a feild. I need to count the
number of 3's, 25's, 399's..etc

 

[John W. Vinson]

I know this is a simple query, but I can't remember how to do it. I need to
count how many times each value repeats in a feild. I need to count the
number of 3's, 25's, 399's..etc

You don't describe much about your table but....

Create a query based on the table. Include the field TWICE.

Change the query to a Totals query by clicking the Greek Sigma icon (looks
like a sideways M).

Leave the default Group By alone for one instance, change it to Count for the
other.

Run the query... or base a form or report on it.