Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SUM TOTAL IN FORM FOOTER
- Thread starter SeanB
- Start date
Databaseguy
MIS
This is straight from the on line help. Perhaps it will solve your problem
About computing a total for a calculated control on a form or report
When computing a total with an aggregate function such as Sum or a domain aggregate function such as DSum, you can't use the name of a calculated control in the Sum function. You must repeat the expression in the calculated control. For example:
=Sum([Quantity]*[UnitPrice])
However, if you have a calculated field in an underlying query, for example,
=ExtendedPrice: [Quantity]*[UnitPrice]
you can use the name of that field in the Sum function, as shown here:
=Sum([ExtendedPrice]) Tyrone Lumley
augerinn@gte.net
About computing a total for a calculated control on a form or report
When computing a total with an aggregate function such as Sum or a domain aggregate function such as DSum, you can't use the name of a calculated control in the Sum function. You must repeat the expression in the calculated control. For example:
=Sum([Quantity]*[UnitPrice])
However, if you have a calculated field in an underlying query, for example,
=ExtendedPrice: [Quantity]*[UnitPrice]
you can use the name of that field in the Sum function, as shown here:
=Sum([ExtendedPrice]) Tyrone Lumley
augerinn@gte.net
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question