Updating original recordset from reordered SQL version?

  • Thread starter Thread starter ormazd
  • Start date Start date
O

ormazd

I need to perform a series of updates on an Access tables, after reordering
the records by a descending field each time. I'm having trouble getting my
head around figuring out how to update the original recordset from the
reordered version. Could someone point me in the right direction for coding
this?
TIA!
 
I need to perform a series of updates on an Access tables, after reordering
the records by a descending field each time. I'm having trouble getting my
head around figuring out how to update the original recordset from the
reordered version. Could someone point me in the right direction for coding
this?
TIA!
Click to expand...

The order of records is completely irrelevant to a Table. Are you assuming
that you can store the order of records in a Table? If so you can't! A table
is an unordered "bag" of records, and an update query doesn't care what order
the records are in, just the key fields' values.

Could you explain the nature of the data, what you're trying to accomplish,
and perhaps some of your current code?
 
Back
Top