G Guest Oct 13, 2004 #1 I have a DB with 1.5 million rows. I want to count each time a unique value happens. Any ideas? Thanks. 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 Oct 13, 2004 #2 -----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.
-----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 Oct 13, 2004 #3 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
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
