Dear Radar:
In order to append new items only, the query would need to eliminate
any existing items from the set of items being appended. This would
be done with a WHERE clause that eliminates those items from the set.
The rules for doing so would be determined by your implementation,
specifically, some set of columns in the table being appended which
uniquely identify items. This would likely be, and almost certainly
should be, the columns making up a unique index to that table,
possibly the primary key, unless you use a surrogate.
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
