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