Adding one time from each record together, on a continuios form

[Guest]

I have a "StartTime" and
"EndTime". I have created a text box in my form that calculates the
difference between the start and end time(labblelled Total Time). Now at the
bottom of the form I would like another text box that adds all of the (Total
Time) text boxes all together to create one grand working total in my form
footer.(continuious form) "Add all of the Total Time) in each record together?
Thanks for any help you can offer!

 

[tina]

Marshall Barton basically answered your question in your previous thread a
couple hours ago this date, titled "Calculate a grand total time from a txt
control calculation". if you don't need to use the DateDiff() function he
posted, then just total your calculated control, as

=Sum(YourCalculatedControlName)

if you've tried that and it isn't working for you, then suggest you use the
expression Marshall posted, as is.

hth

 

[Marshall Barton]

tina, I think you forgot that the aggregate functions can
not operate on form/report controls. They only operate on
fields in the record source table/query.

 

[tina]

you're right, Marsh, i haven't used one in awhile (use it or lose it <g>).
good thing i put in the "...if not working for you, then..." disclaimer.

tina, I think you forgot that the aggregate functions can
not operate on form/report controls. They only operate on
fields in the record source table/query.
--
Marsh
MVP [MS Access]

Marshall Barton basically answered your question in your previous thread a
couple hours ago this date, titled "Calculate a grand total time from a txt
control calculation". if you don't need to use the DateDiff() function he
posted, then just total your calculated control, as

=Sum(YourCalculatedControlName)

if you've tried that and it isn't working for you, then suggest you use the
expression Marshall posted, as is.


at
the
together?