total field on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my 2 subforms I want to be able to get a total of all hours worked on each persons record. How do I start this. Does it start at the query or on the table? Can lead me in the right direction? Each persons hours will change as they work more hours, so it needs to be able to chang
Thank yo
Jen
 
A typical way of addressing this requirement is to include
an unbound text box on either the SubForms Header or Footer
and set its ControlSource to a call to the DSum function

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
On my 2 subforms I want to be able to get a total of all
Click to expand...
hours worked on each persons record. How do I start this.
Does it start at the query or on the table? Can lead me
in the right direction? Each persons hours will change as
they work more hours, so it needs to be able to change
 
On my 2 subforms I want to be able to get a total of all hours worked on each persons record. How do I start this. Does it start at the query or on the table? Can lead me in the right direction? Each persons hours will change as they work more hours, so it needs to be able to change
Thank you
Jen
Click to expand...

You'll need to put a textbox control in the subform's Footer (a
Continuous Form works well for this); set the Control Source property
of the textbox to

=Sum([hours])

(assuming that your table contains a field named Hours).
 
Back
Top