"Running" Sum and Multiplication in Query

dansalmada

Registered User.
Local time
Yesterday, 22:28
Joined
Jun 7, 2004
Messages
16
I have three values A, B, and C in a table

for the first month A=20, B=0, C=0
for the second month B=20 (value of A in month 1), C=110% therefore A=B*C =22
for the third month B should be 22 (value of A in month 2) C=110% therefore A=22*1.1 =24

And so on...


Value C is a constant, but I need values A and B to "Run" through 12 months and all I can get right now are the values for the second month. For the third month B is left as null, it doesn't take the value of A of the second month.

Need Help
 

Attachments

Last edited:

Users who are viewing this thread

Back
Top Bottom