If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sumtotal in a form
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 |
#2
|
|||
|
|||
sumtotal in a form
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" wrote: 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 |
#3
|
|||
|
|||
sumtotal in a form
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" wrote: 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" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|