If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running Sum used in calculation in Report
I have 12 columns, two are running sums (work great), I need those two
running sum calculations to multiply together and that result in another column. I have tried a number of solutions and I'm still stuck. I hope I'm giving enough information. In the below example 2, 81, 4 and 84 are results of running sums of other columns. 2 81 here I need the result of 2*81 4 84 here I need the result of 4*84 |
#2
|
|||
|
|||
Running Sum used in calculation in Report
I would expect that if the totals were needed in the same report section,
all you would need to do is reference the names of the text boxes in an expression like: =txtFirst * txtSecond Duane Hookom MS Access MVP "AccessNewbie" wrote in message ... I have 12 columns, two are running sums (work great), I need those two running sum calculations to multiply together and that result in another column. I have tried a number of solutions and I'm still stuck. I hope I'm giving enough information. In the below example 2, 81, 4 and 84 are results of running sums of other columns. 2 81 here I need the result of 2*81 4 84 here I need the result of 4*84 |
Thread Tools | |
Display Modes | |
|
|