weird issue

jamesmor

Registered User.
Local time
Today, 09:06
Joined
Sep 8, 2004
Messages
126
I have a weird issue going on...I'm running a "Find Duplicates" query on one of my tables, I'm only checking for duplicate values in 2 fields and outputting a third. now this runs fine, unless I use the total's button to group them. When I group them that access instance stops responding. The reason I'm doing this is the third column can have duplicate values, for my purposes it doesn't matter, but I need to be able to see it.

I'm running this against 120k records.

Anyone help a poor man out?
 
Rather than attempting to group in the find duplicates query, create a second query that selects all the data from the find duplicates query and group it in the second query.
 
thanks Pat, that worked.
 

Users who are viewing this thread

Back
Top Bottom