 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008sumtotal 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 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...  SignatureNTC > I have a continous for that records lost time like so..... > Name Starttime Endtime Code Totallost Hours [quoted text clipped - 14 lines] > get anything to work. > Please give t to me step by step as i am a beginner. Thanks 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?? > in your footer put an unbound textbox > [quoted text clipped - 22 lines] > > get anything to work. > > Please give t to me step by step as i am a beginner. Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.