If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Query Duplicate records
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? |
#2
|
|||
|
|||
Access Query Duplicate records
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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "El Cajon Liberty" El Cajon wrote in message ... 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? |
#3
|
|||
|
|||
Access Query Duplicate records
On Sat, 1 May 2010 13:45:01 -0700, El Cajon Liberty El Cajon
wrote: 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! -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Access Query Duplicate records
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "El Cajon Liberty" wrote: 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? |
#5
|
|||
|
|||
Access Query Duplicate records
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "El Cajon Liberty" wrote: 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? |
#6
|
|||
|
|||
Access Query Duplicate records
Post the SQL of your query.
-- Build a little, test a little. "El Cajon Liberty" wrote: 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? |
#7
|
|||
|
|||
Access Query Duplicate records
See other reply.
-- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "El Cajon Liberty" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|