An Append Query will do exactly what you are mentioning unless you do
something to limit which records are added. If there is a unique identifier
field that gets carried over, you could use an "unmatched query" to find the
records in the source table that don't match records currently in the
destination table. Use the unmatched query as the source of the append
query. If there is a Date/Time field in the records, you may be able to
limit the records to only those records that are newer than the latest
date/time in the destination table.
There are other ways to restrict what gets copied, it will depend on what
your data looks like as to how you'll want to do it.
--
Wayne Morgan
MS Access MVP
"Michael C via AccessMonster.com" <u9916@uwe> wrote in message
news:59f8ec70c5769@uwe...
Hello,
I have a table that I am appending 3 seperate tables into. My main
problem
is that each time I append the data, it simply adds to the data already
there.
That might sound ok, except that if I append the data 3 times in
succession,
it copies the same data over 3x. Now I have copies in triplicate. It
used
to only transfer records that weren't already there, but not anymore.
If I can't get the append to append correctly, I was thinking of something
crazy like a code that would wipe my append destination table clean each
time
before I do the append command. That way, there is only one set of
current
data combined from all 3 tables.
Any ideas?
Perry
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200601/1