Doubled data in a Query

[Cachelot]

I have built a query from multiple tables with a specific criteria. In my results from the query I get the right information, from the specific criteria but some info is doubled, some even tripled. What did I do wrong and how can I fix so I get the proper information showing only once?

I appreciate all and any help given.

 

[LonnieJohnson]

Open your query in design view.
Right click in the upper part that contains the tables.
Select properties.
Set the Unique Values property to Yes.

Hope that helps... B-) ljprodev@yahoo.com
ProDev
MS Access Applications

 

[gny]

If you are writing your queries "by hand" (sql code), check the help file for DISTINCT and DISTINCTROW.