Limiting query to 1 record per field value

[mg55345]

I am having problems with duplicate records in a query. The reason for this is hard to explain and it's a very complciated database. I do not want to get rid of the "duplicate entries" (they aren't, really), but I do want to remove them from my report.

What can I do in a query to limit the report to one record per unique field of my choosing?

Thanks in advance for any help.

 

[MSAccessRookie]

I am having problems with duplicate records in a query. The reason for this is hard to explain and it's a very complciated database. I do not want to get rid of the "duplicate entries" (they aren't, really), but I do want to remove them from my report.

What can I do in a query to limit the report to one record per unique field of my choosing?

Thanks in advance for any help.

Look up the DISTINCT command. It can be used to return a single response whenever duplicates are found. See if that is what you need.