removing duplicates

[canberry]

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

 

[MSAccessRookie]

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.

 

[canberry]

where do you find this option in design view

 

[MSAccessRookie]

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

 

[neileg]

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.

 

[gemma-the-husky]

in design view, the unique setting is in the query properties - unique values i think