Report SUM problem 1

[JeroenNL]

Hi there,

I have a report on which I show a bunch of records. One of the fields is called "Expected" and contains some value. Now I want to show the "Total Expected" at the bottom of my report (1 page report). So I put the following in the Control Source of a new textbox in my page footer:

=Sum([Expected])

But this generates an error (shows #Error) and I don't know why. Anyone can help me out?

Thanks,
Jeroen

 

[PaulBricker]

Jeroen, it needs to go in the Report Footer. The Page Footer won't do the calculations.

Paul

 

[JeroenNL]

Thanks Paul, I didn't know the page footer couldn't do calculations. It works perfectly now.

Jeroen