D
Darilyn
I am attempting to create a database that holds my check
register where I can print a report that shows what I
currently have outstanding. In the report I would like to
put in the balance that the bank currently has and have it
calculate the amount remaining after all of my checks have
cleared and all of my deposits have posted.
So far I have gotten the program to accept the current
balance I give it and subtract the debits and add the
credits for each record, but I can't seem to get it to use
the previous record's balance the do the math.
for example:
IF I tell the computer I have a balance of 1000.00 and the
report shows the following fields with the data that
results in the balance colums shows as follows:
check# date credit debit bal
1282 7/22 100.00 0 1100.00
1283 7/23 0 50.00 950.00
Under the same circumstances I would like it to show:
check# date credit debit bal
1282 7/22 100.00 0 1100.00
1283 7/23 0 50.00 1050.00
Can anyone tell me how I might achieve these results?
register where I can print a report that shows what I
currently have outstanding. In the report I would like to
put in the balance that the bank currently has and have it
calculate the amount remaining after all of my checks have
cleared and all of my deposits have posted.
So far I have gotten the program to accept the current
balance I give it and subtract the debits and add the
credits for each record, but I can't seem to get it to use
the previous record's balance the do the math.
for example:
IF I tell the computer I have a balance of 1000.00 and the
report shows the following fields with the data that
results in the balance colums shows as follows:
check# date credit debit bal
1282 7/22 100.00 0 1100.00
1283 7/23 0 50.00 950.00
Under the same circumstances I would like it to show:
check# date credit debit bal
1282 7/22 100.00 0 1100.00
1283 7/23 0 50.00 1050.00
Can anyone tell me how I might achieve these results?