query

  • Thread starter Thread starter sharon
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate showing in query when there shouldn't be 10
Unique values in two fields in query 1
Allow duplicates, but not for the same reference 5
Deleting all duplicates 1
Combine Duplicates in Query 0
Linking Query to table 1
Continued frustration with relationships and queries 1
Access Auto Matching Duplicates? 0

Back
Top