Count Unique Items

S

Sean

I have a DB with 1.5 million rows. I want to count each time a unique value
happens. Any ideas?


Thanks.
Sean
 
G

gmartin293

-----Original Message-----
I have a DB with 1.5 million rows. I want to count each time a unique value
happens. Any ideas?


Thanks.
Sean
.
Sorry but i dont have any idea what your talking
Click to expand...
about,but if its any consolation i'm having serious
problems myself.I've had this computer for 2 weeks and
i'm starting to go slightly mad.
 
J

John Vinson

I have a DB with 1.5 million rows. I want to count each time a unique value
happens. Any ideas?
Click to expand...

Create a totals query, grouping by that item, and selecting Count as
the aggregate function for your table's primary key. This process will
take a while (and will be a bit faster if there is an Index on the
field containing the value).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top