sum

[site]

Hi, All,

I have a report for state informaton.

I have three fields: State, NUM_OF_VEHICLES, AMOUNT

I set up pagefoot for tatal: like, sum([AMOUNT]), sum([NUM_OF_VEHICLES]), but is not works.

I want to get "Whole state" total for Amount, num_of_vehicles.

Thanks for your help.

Jing

 

[Maquis]

You should probably move the total to a group footer or report footer. I'm not sure page footers can even do totals.
Maq B-)
<insert witty signature here>