Subtracting Previous Record

G

Guest

How can I create a field in a query which is the difference between the
current record and the previous one? For example:

Field1 Field2
2 2
6 4
13 7
24 11

Field2 would be the calculated field.
 
G

Guest

I was afraid it would be something rediculously complicated like that. I am
pretty new to using VBA. I don't suppose you could point me in the right
direction?
 

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

Select to reference an other record or row 1
Group By, Max and Min 2
IIF Function Within A Query 6
Pull a value from previous record for query 4
Invalid data on Left Join query 2
Left join query produces invalid results 1
Shift several columns in table 4
Using If or Iif to determine a value 3

Top