Appen Query with new records only

D

DLAM

Hi All,

I had an Append query, What can I do to make the Append query only appen new
records that have not been append to the spcify table ? Also, Can I use the
same append query and when I type in sales rep. name "John" then it will
append to a specific table, if its "Ann" then it append to Ann's table ?

Thanks
 
J

Jeff Boyce

Not sure I understand your data design well enough to offer suggestions.
What you described is troubling, though.

Do you have multiple tables, all essentially identical, except for
differences noted in the names of the tables? If so, this is not a
well-normalized design, and you will have to find work arounds to get Access
to do what it does well on a normalized data structure.
 
Top