PC Review


Reply
Thread Tools Rate Thread

Access query duplicates the table records

 
 
El Cajon Liberty
Guest
Posts: n/a
 
      1st May 2010
Everytime I run my query it adds another set of the table records. Help!!

 
Reply With Quote
 
 
 
 
John W. Vinson
Guest
Posts: n/a
 
      1st May 2010
On Sat, 1 May 2010 13:58:01 -0700, El Cajon Liberty
<(E-Mail Removed)> wrote:

>Everytime I run my query it adds another set of the table records. Help!!


Change the query from an Append query to a more appropriate query for your
problem.

Bear in mind that we're unable to see your screen and don't know what your
query might be. Please open it in SQL view (View... SQL on the menu) and copy
and paste the SQL string to a message here, and indicate what you intend the
query to do for you.
--

John W. Vinson [MVP]
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Appending a table by adding only records who are not duplicates Adam-Network Admin Microsoft Access Database Table Design 2 21st Oct 2009 07:51 PM
Changing criteria in an access query based on a set of records in a table New-user via AccessMonster.com Microsoft Access Queries 3 3rd Aug 2005 06:06 PM
Append query duplicates records Jason Morin Microsoft Access Queries 4 17th Mar 2005 12:45 AM
Unique Records- query as duplicates - Access 2002 =?Utf-8?B?UmF5?= Microsoft Access Database Table Design 1 28th Jun 2004 07:38 PM
Deleting records from find duplicates query Toan Chau Microsoft Access Queries 0 4th Mar 2004 09:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:44 PM.