Re: Automating a query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I forgot to ask you to set
the Criteria....

plus... you should be able
to just keep running code
and *more records* will be
appended.

If you delete all the records in "test,"
then set index of the field(s) in "test"
that were your primary key
in the original table to

"No Duplicates"

then the code should stop
adding duplicates (silently).

good luck,

gary


.