Update Queries

[Jake]

Hi

Sorry, this was an earlier posting, hope that someone might be able to help

I am using an append query to append data into a blank table (source of data
is linked from a Lotus Notes db)

I then need to run an update query on the data which has been appended to my
table.

HOWEVER, first I need to remove the duplicates from my my newly appended
(but not yet updated) table

How would I do this please?

Cheers

Jake

 

[Les]

Did you try setting the unique values property to yes in
the append query?