Totals

[Calvin]

I am building a report to track how many years someone has been our customer.
I have a field that states their annual contract amount. My goal is to take
the number of years they have been customers and multiply that by their
contract amount to give me their total contract worth.

I've done this successfully but in my report i want a total for all the
contracts. I am trying to put in the footer Sum[Worth] but when I run the
report it just says worth before it opens and gives me a box to type
something.

I don't know if its because I am trying to calculate a box that is using a
formula=( [years] * [contractamount] But I want the total for all customers
please help.

what do i do?

 

[John Spencer]

Try the following
=SUM( [years] * [contractamount])

You must Sum a field or an expression that contains the fields. You cannot
sum a control.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..