Eliminating Duplicates from the Query Results

[Moxioron]

Hello all.

What I am trying to do is eliminate duplicates from the query results. I don't want to delete the record from the table, just have the query reflect only one record, not both.

Hope that made sense.

Thanks for you help.

 

[boblarson]

If they are truly duplicates (no field different) then one question is how is that possible? But for those you could modify the query to use SELECT DISTINCTROW...etc.

 

[Moxioron]

It's a table full of transactions that come in more than once. Sometimes up to three times. So they are not truly 'duplicates' as they come in on different days, but I only need to count them once for my query.

But I figured it out. I changed my Query to a totals and it worked.

 

[boblarson]

It's a table full of transactions that come in more than once. Sometimes up to three times. So they are not truly 'duplicates' as they come in on different days, but I only need to count them once for my query.

But I figured it out. I changed my Query to a totals and it worked.

The distinctrow would work too (and be more efficient than the grouping) as long as you don't include the changing date field (which you couldn't include in the grouping query either).