Calculations to come up on a report

[Guest]

Hello Folks:

Here's an example below of what I'm trying to do:

Previous months comp total $100 (1)


Fund Date Comp Credit
722A 3/1/05 $1.00 (2) $101.00 (3)
722A 3/2/05 $10.00 $111.00
722A 3/3/05 ($5.00) $106.00

I want to take the Previous months comp total (1) and add the
current days comp to it (2). The following day i want to take the
updated credit amount from the previous day (3) and add to it the current
days compensation for the new value.

I need to have this need to come up on a form and in a report.
FYI, I'm not very experienced at visual basic.

 

[Rick B]

No need to post in every newsgroup. Please stick to one post.