Update Sequencing

  • Thread starter Thread starter Paul Smith
  • Start date Start date
P

Paul Smith

Update query won't perform updates in sequence of the
driving table. Driving table is in primary sequence
within secondary date sequence and is to update the latest
date last in many to one relation. Actual updates occur
randomly.
 
Update query won't perform updates in sequence of the
driving table.
Click to expand...

Well, you're making the assumption that the driving table has a
sequence. IT DOESN'T. A Table is an unordered "bag" of data; there is
no usable first record or last record or eleventh record.
Driving table is in primary sequence
within secondary date sequence and is to update the latest
date last in many to one relation. Actual updates occur
randomly.
Click to expand...

You'll need to use query criteria to select which record to update
based on the contents of that record. If you don't, Access (or any
relational database) will update the records in whatever order the
query optimizer finds convenient.

If you could post a description of your tables, and what you want
updated and how, someone should be able to help come up with a more
complex query to do what you wish.
 
Back
Top