Prevent Duplicates using an Append Query

[pete.trudell]

Morning, we have 5 offices throughtout the state which use daily an
append query to update a Master Table in Austin. We need to find a way
to flag the records once they are appended to that table to prevent
appending them again later.

The query uses a date range to select records from the local table to
copy to the Master. Usually, we only select a days worth of records.

Thanks, Appreciate any suggestions.

 

[Kevin Jameson]

you cant do this with microsoft access 2003

you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

HTH

Kevin

 

[Jeff Boyce]

Pete

If you have a table to which you are appending the records, and if you have
a way to tell what constitutes a "duplicate", open that table in design
mode and set a unique index on that/those field(s). That way, when your
append query runs, any records previously appended will be rejected if it
runs again.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Jeff Boyce]

Disregard the "you cant do this" message. It is SPAM (or worse), and has
been showing up all over the newsgroups.

Regards

Jeff Boyce
Microsoft Office/Access MVP