Count repeats

  • Thread starter Thread starter RobertM
  • Start date Start date
R

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
 
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
Click to expand...

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.
 
Back
Top