Access: How can I pull values from previous record into current?

  • Thread starter Thread starter Emsstop
  • Start date Start date
E

Emsstop

I am trying to put together a form that manages inputs and outputs on a daily
basis, eg:

Date In Previous Out Balance

11/8/07 600 100 400 300
12/8/07 500 300 600 200
13/8/07 400 200 300 300

I want to bring the Balance of the previous day (closing balance) into the
Previous field of the current day (opening balance). It's just like banking
and financial accounting so it must be easy!
 
From your description, you have a ... spreadsheet! Is there a reason you
aren't using Excel or some other spreadsheet to manage this?

Including [Balance] & [Previous] in your table (this is my assumption, based
on your description) is both unnecessary and risky. What happens if you
calculate [Balance] for 11/8/07, then someone corrects the (mistaken) entry
for [In] on 11/8/07? How does [Balance] get updated? In a spreadsheet, you
have a formula ... not in Access! And how does [Previous] for 12/8/07 get
(re-)calculated? Again, spreadsheet, si, Access, no!

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top