query returns each record twice... (1 Viewer)

[lipin]

I have a query that returns a duplicate record for each record it is supposed to return. I have checked the tables over and over and there is only one record, but the subforms that are fed by the query show 2 exact copies of each record they are supposed to show. But even out of the subforms I can run the query on its own and I get the same thing.


what's going on?

 

[neileg]

Post the SQL of your query.

 

[lipin]

i think I got it..

On the field that was the relationship between the two tables, there were some duplicate records in the main table, where there usually isn't but occasionally could need to be dups. So do I need a new relationship?

 

[neileg]

If you have both tables in the query, and there are some duplicates in either of the tables, you will get a result in your query for each match. So if ID XYZ123 appears twice in one table and three times in the other you will get 6 records in your query.

Once you know what is happening, you need to decide what it is you want.