I need to append data from a linked table that holds data that continues 
to be updated to a table that I will query in a webpage - and I need the 
query to verify no duplicates and append only non-dupe data...

Any suggestions?

-Jeremy

If you like the idea of using error-trapping as a useful check, just set an 
index UNIQUE on the combination of fields you want to keep unique. Then, just 
let Access do the job - run your query and just suppress warning messages 
(DoCmd.Setwarnings = False). 

HTH

   Claudio de Biasio
     Team 97 S.r.l.

Quoting Jeremy Meiss <jmeiss@y...>:

> I need to append data from a linked table that holds data that continues
> 
> to be updated to a table that I will query in a webpage - and I need the
> 
> query to verify no duplicates and append only non-dupe data...
> 
> Any suggestions?
> 
> -Jeremy
>