weird issue

[jamesmor]

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?

 

[Pat Hartman]

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.

 

[jamesmor]

thanks Pat, that worked.