Query Problem (Duplicates)

  • Thread starter Thread starter Bliss
  • Start date Start date
B

Bliss

I have a largequery where 90% of the data output is correct, but then I get a
high number of duplicates (up to 30 of the same) for the remaining 10%--the
data is correct, but there are many duplicates--any help would be appreciated.
 
The simple, but slow, fix would be to open the query in SQL view and change
where it says SELECT to SELECT DISTINCT.

You can also do the same thing by making it a Totals query with every field
a GROUP BY.

Either should get rid of dupes but could make the query slow. There might be
a better way if we could see the query. When in SQL view, copy and paste the
SQL statement here.
 
I have a largequery where 90% of the data output is correct, but then I get a
high number of duplicates (up to 30 of the same) for the remaining 10%--the
data is correct, but there are many duplicates--any help would be appreciated.
Click to expand...

Correct the error in the query.

If you would like help doing so, please open the query in SQL view and post
the SQL text here. It would help to indicate what tables you have and how they
are related.
 
Back
Top