Running total in Form Footer

I

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.
 
T

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
 
I

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Totals 4
Total cost stored in a field 2
Total only specific records on a continuous form 2
Sum By Date in Access 2002 Form Footer 2
Total Detail on Continuous Form 2
Total in form 1
Total of calculated field in a form 3
Delay in getting subform total to calculate 2

Top