Eliminate Duplicated

[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?

 

[Roger Carlson]

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.

 

[Daniel Pineault]

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.