Removing duplicate records in a query

J

Jessica

Hi,

I have searched high and low and have been unable to find an answer. I have
a query that because of the way that it is set up returns duplicate records.
It is not that there are duplicate records in the tables. I need to be able
to have the query remove duplicate records based on a specific field in the
query. IS there a way to do this?

Thanks!
 
X

xRoachx

Hey Jessica, can you post the SQL for the query and kindly describe what you
are trying to accomplish with the query? This will help in providing you
with a more accurate answer.
 
J

John Vinson

Hi,

I have searched high and low and have been unable to find an answer. I have
a query that because of the way that it is set up returns duplicate records.
It is not that there are duplicate records in the tables. I need to be able
to have the query remove duplicate records based on a specific field in the
query. IS there a way to do this?

Thanks!
Click to expand...

Make it a Totals query using the Greek Sigma icon. Group By this
field; and use First as the "totals" operator for the other fields.

John W. Vinson[MVP]
 
Top