sumtotal in a form

  • Thread starter Thread starter jackrobyn1
  • Start date Start date
J

jackrobyn1

I have a continous for that records lost time like so.....
Name Starttime Endtime Code Totallost Hours
Paul 06:00 06:45 MF 00:45
Keith 08:25 10:00 TC 01:35
Jack 10:10 11:30 MF 01:20
Fred 12:30 13:05 TC 00:35

SUBTOTALS ??????
total TC = 02:10 total MF = 02:05 total Lost = 04:15

The form gets it data from a query call LostTimeQRY wich works out the time
difference between the Starttime and Endtime and formats the Totallost into
hh:mm, What i would like is the formulas that would give me the above
subtotals on the footer of the form. Regardless of the results of the query i
need it to display these subtotals for the records shown on the form...... Is
this possible? is it a text box i should use? ive tried a few things but cant
get anything to work.
Please give t to me step by step as i am a beginner. Thanks
 
in your footer put an unbound textbox

inside your unbound textbox put: =Sum([NameOfYourControl])

this much will work on your total last hours because it is a true sum. I
don't know what totalTC or total MF...but they don't look like sums so not
sure on those two...
 
Its just displaying # error, i've done exactly as you said but no luck, is it
because my TotallostHours control is a text box? Should it be some other kind
of control??

MF and TC are the lost time codes we use and it would be good if a formula
could add up each codes lost time seperatly as well as together. As a query??

NetworkTrade said:
in your footer put an unbound textbox

inside your unbound textbox put: =Sum([NameOfYourControl])

this much will work on your total last hours because it is a true sum. I
don't know what totalTC or total MF...but they don't look like sums so not
sure on those two...
--
NTC


jackrobyn1 said:
I have a continous for that records lost time like so.....
Name Starttime Endtime Code Totallost Hours
Paul 06:00 06:45 MF 00:45
Keith 08:25 10:00 TC 01:35
Jack 10:10 11:30 MF 01:20
Fred 12:30 13:05 TC 00:35

SUBTOTALS ??????
total TC = 02:10 total MF = 02:05 total Lost = 04:15

The form gets it data from a query call LostTimeQRY wich works out the time
difference between the Starttime and Endtime and formats the Totallost into
hh:mm, What i would like is the formulas that would give me the above
subtotals on the footer of the form. Regardless of the results of the query i
need it to display these subtotals for the records shown on the form...... Is
this possible? is it a text box i should use? ive tried a few things but cant
get anything to work.
Please give t to me step by step as i am a beginner. Thanks
Click to expand...
Click to expand...
 
Back
Top