query

S

sharon

I have 3 tables that I am pulling information from for a query - the tables
are related but when I run the query it duplicates the information....when
there are no duplicates in the forms.
 
J

John W. Vinson/MVP

sharon said:
I have 3 tables that I am pulling information from for a query - the tables
are related but when I run the query it duplicates the information....when
there are no duplicates in the forms.
Click to expand...


It may be doing exactly what it's designed to do. If you have two tables in
a one-to-many relationship, a Query joining them will show as many repeats
of the "one" record as there are matching records in the "many". That's just
how queries are supposed to work!

If this isn't what you're expecting or getting, please open the Query in SQL
view and post the SQL txt here; also indicate what you're seeing, and what
you would like to see instead.
 
Top