Counting Question....

[Jeff Uchtman]

Access database. What is the best method to count a field that has the
numbers 1 - 93 in it, over 1008000 rows long. Trying to obtain how many
times 1, 2, 3 etc show up in this field.

Thanks
Jeff

 

[Jeff Uchtman]

Got it, thanks anyway

Jeff

 

[Bob Barrows]

Got it, thanks anyway

Jeff

Just in case:
You decided to use a grouping query with the Count(*) aggregate function,
right? You didn't bring all the records to the client and loop through them,
did you ...?

Bob Barrows

 

[Tom B]

Just my two cents, but it sounds like a candidate for a database upgrade.

 

[Jeff Uchtman]

Yes, its going to MS-SQL. Did it by doing:
SELECT [Locality_Code], Count(*) AS Total
FROM Voters
GROUP BY [Locality_Code];
Thanks
Jeff