 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / August 2006Subtracting Previous Record
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. 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.  SignatureSteve Clark, Access MVP FMS, Inc http://www.fmsinc.com/consulting Professional Access Database Repair *FREE* Access Tips: http://www.fmsinc.com/free/tips.html > How can I create a field in a query which is the difference between the > current record and the previous one? For example: [quoted text clipped - 6 lines] > > Field2 would be the calculated field. 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? > 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 [quoted text clipped - 10 lines] > > > > Field2 would be the calculated field. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.