Access Query Duplicate records

  • Thread starter Thread starter El Cajon Liberty
  • Start date Start date
E

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?
 
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.
 
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?
Click to expand...

Please open the query in SQL view and post the SQL text here. We can't fix
what we can't see!
 
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
 
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
 
See other reply.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top