In a query

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

In a query how can I get the previous record value of a field and compare it
to the current record value of the field? I want to try and calc the
difference of a field value from the previous record to the current record
and show the change in value of the field.


Thank you in advance for any help,
Mike
 
In a query how can I get the previous record value of a field and compare it
to the current record value of the field? I want to try and calc the
difference of a field value from the previous record to the current record
and show the change in value of the field.


Thank you in advance for any help,
Mike
Click to expand...

A "Self Join" query, or a DLookUp, can help here. The details vary
depending on what *YOU* consider to be "the previous record" - tables
have no order.

Could you describe the nature of the data, perhaps with the SQL of
your query?

John W. Vinson[MVP]
 
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

field value concatenation VBA 1
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
Special characters 3
Access Count query 1
How to create a new field from other record fields in a table 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Changing Form BackColor in VB 1
Populate combo box from current record 3

Back
Top