Refresh report calculated control (1 Viewer)

[cpampas]

Hello

In the footer section of a countinous report I have a calculated field (mpreco)

=Sum([precoMaq])

When previewing the report the calculation doesnt show, but if I click on the control it will

i've tried on the format event and others to refresh the control
Me.mpreco.Requery

but still with no results, any thoughts ?

 

[arnelgp]

some events doesn't fire on Report view.
you probably need to use continuous subform.

 

[Ranman256]

Summing a field that is null will give a null. (1 bad apple)
so, in the query , make sure you prevent null with NZ([field],0)
THEN you can sum.

 

[cpampas]

Ranman, the query does not return any null values
Anyway I changed it to a countinous form, and again the same problem, but I noticed that when opening the form the calculations were displayed correctly, but when changing to design view and again to form view the calculations were not made ( I wonder why ??)
So, I placed on the open event of the form a me.requery, and it is working, I just do not understand the need for requering the source query that no parameters only fixed conditions retrieving data from a table.

 

[cpampas]

humm, back with the problem again, this is disturbing

 

[cpampas]

me.recalc did the trick
thanks