G
Guest
Hello Folks:
Here's an example below fo what I'm trying to do:
(1)Previous months compensation total $3,799,595,90
Fund Date Compensation Credit
722A March 01, 2005 ($0.02) $3,799,595.88 (3)
722A March 02, 2005 $10,000.01 $3,809,595.89
722A March 03, 2005 ($308,578.30) $3,501,017.59
I want to take the Previous months compensation total (1) and add to it the
current days compensation (2). The following day the query needs to take the
updated credit amount from the previous day (3) and add to it the current
days compensation for the new value.
I would like to somehow have a query hold this information. These values
need to come up on a form and in a report. I'm open to suggestions.
Here's an example below fo what I'm trying to do:
(1)Previous months compensation total $3,799,595,90
Fund Date Compensation Credit
722A March 01, 2005 ($0.02) $3,799,595.88 (3)
722A March 02, 2005 $10,000.01 $3,809,595.89
722A March 03, 2005 ($308,578.30) $3,501,017.59
I want to take the Previous months compensation total (1) and add to it the
current days compensation (2). The following day the query needs to take the
updated credit amount from the previous day (3) and add to it the current
days compensation for the new value.
I would like to somehow have a query hold this information. These values
need to come up on a form and in a report. I'm open to suggestions.