Queries: Values from previous records

P

Pankaj

I have two columns in a query - OpgStock and ClgStock. I want OpgStock values
to be equal to ClgStock values of the previous records. Pls guide.
 
S

Steve Schapel

Pankaj,

How do you know which is the "previous record"? Does each record have a
DateCreated field or some such, to indicate their order? Or maybe a
sequential numbering system?
 
P

Pankaj

Steve,
Thanx for response. The query does not have Id field and is sorted on a date
field. "Previous" means another field of a record that just precedes the
current record (to be updated).
Would like to add an auto numbering field in the query if you tell me how.
 
Top