removing duplicates

canberry

Registered User.
Local time
Yesterday, 16:21
Joined
Sep 22, 2008
Messages
36
Hi all. A query i am running giving me duplicates for some records. For those particular rows that are duplicated, has the exact feilds with the same data as the one above it. But it only occurs with some records
 
Hi all. A query i am running giving me duplicates for some records. For those particular rows that are duplicated, has the exact feilds with the same data as the one above it. But it only occurs with some records

Check out the Distinct() and the DistinctRow Functions. I am fairly sure that one of them can help you.
 
where do you find this option in design view
 
where do you find this option in design view

I am not sure that it is available in design view. I always enter those in the SQL view. You will probably want to read up on both of the functions in order to to determine which one is right for you.

UPDATE:

I was taking a look at Alan Browne's Site, and came across this item. I know the article refers to handling Nulls, but I also believe that it answers your question as to how to find the option in design view for DISTINCT. I am still not sure about DISTINCTROW.

http://allenbrowne.com/bug-12.html
 
Last edited:
If you are getting duplicates, then either you actually have duplicates in your data, or there is something about the structure of the query causing duplicates.

Can you post the SQL view of your query so we can have a look.
 
in design view, the unique setting is in the query properties - unique values i think
 

Users who are viewing this thread

Back
Top Bottom