Access Query Duplicate records

[El Cajon Liberty]

I am using Access 2007, and my query adds another set of the same records
every time I open it. How can make the query only include each record once?

 

[Arvin Meyer [MVP]]

Make sure that all tables are joined in the query. If a table with 2 records
is unjoined it becomes a Cartesian product and you get twice as many
records.

 

[John W. Vinson]

On Sat, 1 May 2010 13:45:01 -0700, El Cajon Liberty <El Cajon

I am using Access 2007, and my query adds another set of the same records
every time I open it. How can make the query only include each record once?

Please open the query in SQL view and post the SQL text here. We can't fix
what we can't see!

 

[Jerry Whittle]

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

 

[Jerry Whittle]

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

 

[KARL DEWEY]

Post the SQL of your query.

 

[Dorian]

See other reply.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".