Problem to use calculated field in second level footer

  • Thread starter Thread starter CESI
  • Start date Start date
C

CESI

In a report I have three level of subtotal; I am trying
to use a calculated field (a textbox named "IDTotal") in
a subfooter of second o third level, Access asked
[IDTotal]as parameter. Why ?
Thanks.
 
CESI said:
In a report I have three level of subtotal; I am trying
to use a calculated field (a textbox named "IDTotal") in
a subfooter of second o third level, Access asked
[IDTotal]as parameter. Why ?
Click to expand...


It sounds like you are trying to Sum a text box instead of
record source fields. The aggregate functions (Count, Sum,
etc) work with fields in the report's record source
table/query, they are unaware of controls in the report.

If the text box's calculation is done with an expression
(not in VBA code), then you should use Sum on the same
expression. For example, if the text box has the expression
=Quantity * Price
then the footer text box should use the expression
=Sum(Quantity * Price)
 
Back
Top