Running total in Form Footer

[Indyexe]

I am trying to see a running total of the labour costs for all records for
the year in a box on the Form Footer that is automatically updated as the
data in the labour cost box is altered. I can get a query to do the
calculation but can not get it to dynamicly update and display the result.

Any help you can give would be gratefully received.

 

[Tom van Stiphout]

On Wed, 17 Jun 2009 09:54:02 -0700, Indyexe

Try this formula:
=Sum(myLaborCostField)
(replace myObjectNames with yours)

-Tom.
Microsoft Access MVP

 

[Indyexe]

Tom

Many thanks for that it has saved me a lot of trial and error as I was
looking at it from totally the wrong angle.

 

[Jeanette Cunningham]

Hi Indyexe,
you can use Me.Recalc to force access to update a calculated control.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia