Update query won't work

G

Guest

I want to update data from one table to another, however the destination
table contains duplicates of the field i'm using to match against the source
table.

I only want to update the last instance of the duplicate, not the ones
before it. Every update query i've tried to make has not worked because using
the Last formula in the query to decide which record should be updated makes
the record uneditable and I get an 'Operation must use an updateable query'
error.

How can I do this update without using a locked query?


Thansks!
 
G

Guest

How would you determine the 'last instance of the duplicate', do they have a
time stamp or AutoNumber ID?
 

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

'Operation must use an updateable query' 1
Update query error: "Operation must use an updateable query" 8
Using the Update query 1
Non Update Form 6
Count of records and Update 3
Update query to set value based on position in recordset 2
Stored date is not being recognised 1
query to show all differences between two records? 1

Top