Math Formula

[Guest]

On my form I have a subform which is created as "Continuous Forms". The form
is used to track comp time earned at work. I have two fields that collect the
data which are "Hours Earned" + Hours Used"

At the bottom of the form I would like to create three fileds

Total hours earned + Total hours used + Hours Balance

Can't seem to come up with a formula that sums all the rows of data, only
per row.

Need Help - Thanks

 

[shanesullaway via AccessMonster.com]

Hey George,

Hope I'm following what your wanting to do, but one thought that hits me is
to add an unbound text control on the "row" and Sum the 3 controls (Total
Hours Earned, Total Hours Used, and Hours Balance) then in the Footer of your
subform add another unbound text control and have it Sum the first unbound
text control.

HTH,
Shane

 

[Arvin Meyer [MVP]]

In the subform's footer, you need a field with a control source summing the
data in its source field. One of them would have the following
controlsource:

= Sum([hours earned])

You can set the height of the textbox to 0" and stuff it at the top of the
footer, then set the footer height to 0". On the main form, add a text box
who's controlsource is:

=Forms![MainformName]![SubformControlName].Form![Name of textbox in footer]

after adding controls for both [hours earned] and [Total hours used], add a
3rd textbox on the main form to total the other 2.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access