Removing duplicate records in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Writing SQL code to delete duplicate records 0
Querying for duplicate records... 6
Remove duplicate records 2
Copy or Duplicate Record Woes 3
Query Delete Duplicates 2
query 4
Yet another duplicate record dilemma 7
Duplicate records - eliminate from totals 11

Back
Top