Access query returning duplicated records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EA - 23 Apr 2008 19:46 GMT

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?

Reply to this Message

Golfinray - 23 Apr 2008 19:57 GMT

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.

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

Reply to this Message