S
SL
I have a continuous subform with a DSum calculation in a textbox in the
detail section, showing previous week totals.
=DSum("PltTotal","Union_PrevPltDtl").
This works fine and gives the correct total.
E.g.
Wk 1 £1000
Wk 2 £2000
Wk 3 £3000
However I want a sub total in the footer for all the weeks, so the total
would be £6000 using the example above.
However, because the totals are calculated from the query using the date and
another query if I try to use =Sum(DSum("PltTotal","Union_PrevPltDtl")) in
the footer, it just takes the 1st value returned and multiplies it by the
number of records returned so it would return £3000 using the example above.
Can anyone advise how I can calculate the total for all week's returned?
Help would be much appreciated.
Thank You
Sonya
detail section, showing previous week totals.
=DSum("PltTotal","Union_PrevPltDtl").
This works fine and gives the correct total.
E.g.
Wk 1 £1000
Wk 2 £2000
Wk 3 £3000
However I want a sub total in the footer for all the weeks, so the total
would be £6000 using the example above.
However, because the totals are calculated from the query using the date and
another query if I try to use =Sum(DSum("PltTotal","Union_PrevPltDtl")) in
the footer, it just takes the 1st value returned and multiplies it by the
number of records returned so it would return £3000 using the example above.
Can anyone advise how I can calculate the total for all week's returned?
Help would be much appreciated.
Thank You
Sonya