Subtracting Previous Record

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

 

[[MVP] S.Clark]

The way I would do it is to create a destination table that has these
fields. I would use VBA to step through the records to write in the Field2
value.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

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