Update Queries

  • Thread starter Thread starter Jake
  • Start date Start date
J

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
 
Did you try setting the unique values property to yes in
the append query?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
Access 2010 append query to SQL is very slow 0
Schedule Auto run Query on append table 0
Exicute an append query in an after update event 0
Append Query is not working 1
Make one final list from four sources 1
How to append running number 1
update and append queries 1

Back
Top