Eliminate Duplicated

  • Thread starter Thread starter W. Guy Delaney
  • Start date Start date
W

W. Guy Delaney

I have a querry, which when I run it, displays a duplicate of every record
in my database. How can I eliminate duplicated in this querry?
 
That's hard to say for sure. There could be a number of reasons. The
easiest thing to try would be to add the DISTINCT predicate to you SQL
statement:

SELECT DISTINCT ... <field list>...

If that doesn't work, come back with a description of your tables, fields
and the sql of your query.
 
It depends on how your query is built.

Is it returning duplicates because there are truly multiple records with the
same information (which would indicate a non-normalized database) or is it
because of the way your query is setup.

In certain case performing a Group By can eliminate duplicates. That said,
for us to properly help you, post your query's sql statement.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Back
Top