Queries: Values from previous records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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.
 
You must log in or register to reply here.

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

Unique values in two fields in query 1
VBA - retrieve data on last create named range from previous inserted named range 0
Delete Multiple records 2
Hiding dates Query fields 5
acnewrec? 1
Re: Pass field value selected in Combo Box to SQL Query 1
Copy data from previous record 4
VBA: How can I use a string variable as autofilter criteria? 4

Back
Top