Access query returning duplicated records

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?
 
G

Golfinray

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.
 
Top