Count Unique Items

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


Thanks.
Sean
 
-----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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique Count 1
Establishing a Count of Unique Records utilizing Parameters 3
Counting records in a query 9
News Largest data breach revealed - 773m email addresses and 21m passwords published 12
Count Distinct Values In Several Columns or Fields 4
Unique Value's in Query Issue 1
Value Counter - Please Help 1
'Count' query not working 5

Back
Top