Quick one

[jamesT]

I have a sub form which has a filed call txtNetTotal
This txt boc calculates the number or products * the price
=Sum (SellingPrice]*[Quanitiy]

That works

then in the Footer I have a txt box called grand total
Which totals the lot.

=Sum[txtNetTotal]
But I get the #Error in the txtbox

Not sure why

thanks in advance for any help

 

[Pat Hartman]

You cannot refer to controls in aggregate functions. You need to repeat the calculation. I know it seems funny since that's the same calculation but the fact that it appears at different grouping levels means that its scope is different for each group.

=Sum(SellingPrice]*[Quanitiy])