C
cthorne
I've been racking my brain for an 'easy' way (I'm not a programmer) to tell
Access to take a 'closing' field's value from the previous day's (date field)
record and use it as the 'opening' field's value on the current record.
Please note, this is not a running sum total......
Ex: Day Opening Closing
1 100
2 100 50
3 50 250
4 250 etc.
Right now I'm using the expression =[closing] in the Property Control
Source for the field called 'opening'. It works, but returns the value for
the current record, not the previous day's record.
Any help would be appreciated.
Carol
Access to take a 'closing' field's value from the previous day's (date field)
record and use it as the 'opening' field's value on the current record.
Please note, this is not a running sum total......
Ex: Day Opening Closing
1 100
2 100 50
3 50 250
4 250 etc.
Right now I'm using the expression =[closing] in the Property Control
Source for the field called 'opening'. It works, but returns the value for
the current record, not the previous day's record.
Any help would be appreciated.
Carol