Access query returning duplicated records

  • Thread starter Thread starter EA
  • Start date Start date
E

EA

I have a select query where I am doing a left-join with two other tables, but
the query output is almost double the number of records in the table I am
querying.

Does anyone know what could be happening?
 
In my experience, that problem is almost always improper joins, keys, or
relationships. Make sure you have a primary key (autonumber may be best for
many tables,) go into your table in design view and check for sure. Then
check tools/relationships to see how you have the tables related. Then it
could be join types. One of those usually fixs the problem.
 
Back
Top