Running Sum used in calculation in Report

  • Thread starter Thread starter AccessNewbie
  • Start date Start date
A

AccessNewbie

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
 
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
 
Back
Top