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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Total for all pages

Status
Not open for further replies.

site

Programmer
Oct 23, 2001
44
AT
Hi, Guys,

How to set up total for All pages?

I tried to set up pagefoot for total, like "Sum(field)", but doesn't work.

Thanks

Jing
 
This is straight out of the help file:

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])
 
You can also get an error with some calculations if the underlying field and the bound control have the same name.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top