A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

sumtotal in a form



 
 
Thread Tools Display Modes
  #1  
Old May 9th, 2008, 03:01 PM posted to microsoft.public.access.forms
jackrobyn1
external usenet poster
 
Posts: 43
Default 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  
Old May 9th, 2008, 03:55 PM posted to microsoft.public.access.forms
NetworkTrade
external usenet poster
 
Posts: 825
Default 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  
Old May 9th, 2008, 10:31 PM posted to microsoft.public.access.forms
jackrobyn1
external usenet poster
 
Posts: 43
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.