See the thread 'Append query question!' elsewhere in this newsgroup for an
example.

--
Brendan Reynolds
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11118-fast-append-query-question.html
Access MVP

"VisualBasic@versatel.nl" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11118
news:e6bmfe$4ho$1@news1.zwoll1.ov.home.nl...
> Hello,
>
> Does anyone know how to create one or more queries (the fastest way that's
> possible) that adds from one table to another table the records but if the
> current record already exist it must deny and goto next record.
>
> Thanks a lot in advance,
>
> Best regards,
>
> vb-er
>