Appen Query with new records only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top