Updating original recordset from reordered SQL version?

[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!

 

[Alex Dybenko]

Hi,
you can loop through one recordset, for each record locate corresponding
record in other recordset using primary key and recordset's FindFirst method

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[John W. Vinson]

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!

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?