A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Query Duplicate records



 
 
Thread Tools Display Modes
  #1  
Old May 1st, 2010, 09:45 PM posted to microsoft.public.access.gettingstarted
El Cajon Liberty
external usenet poster
 
Posts: 1
Default 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  
Old May 2nd, 2010, 02:16 AM posted to microsoft.public.access.gettingstarted
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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  
Old May 2nd, 2010, 03:50 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old May 3rd, 2010, 08:39 PM posted to microsoft.public.access.gettingstarted
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default 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  
Old May 3rd, 2010, 08:45 PM posted to microsoft.public.access.gettingstarted
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default 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  
Old May 3rd, 2010, 08:45 PM posted to microsoft.public.access.gettingstarted
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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  
Old May 3rd, 2010, 08:48 PM posted to microsoft.public.access.gettingstarted
Dorian
external usenet poster
 
Posts: 542
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.