Add fields in current form

[pekuiper]

In Access 2003 I have a form that people are entering in data. It consists of 10 rows of information. Field examples: time1, time2, time3, etc. The time is: 1 1/5 hour = 1.5, 10 min = .166. I know how to add a sum to reports but how can I get the total field at the bottom of the form like the report? This way they can see the total time for the aprt they are running.

 

[KenHigg]

Can't you just do something like the following in the unbound total text box?

=me!myTime1 + me!myTime2

???

 

[pekuiper]

Thanks

Thanks for your responce - whare do I put this? Control Source?

 

[KenHigg]

Yes...

???
ken

 

[pekuiper]

This is what come up when I put it in
=[me]![myProcessSheetTime]+[me]![myProcessSheetTime1]+[me]![myProcessSheetTime2]+[me]![myProcessSheetTime3]+[me]![myProcessSheetTime4]+[me]![myProcessSheetTime5]
when I vier the form I get #Name?
I must still be doing something wrong because I have always recieved the #name? error.

 

[KenHigg]

My bad for not explaining better. This is not the only way but I would add them in the form's underlying query. Then put that filed in the control source for the total box.


ken

 

[pekuiper]

Sorry - I am lost now - I am only self taught beginner at this – thanks for your help any how.

 

[KenHigg]

Is the form based on a query?

 

[pekuiper]

No - I have others based on query's but not this one because it is for data entry. I am thinking I should re-do it before it's 2 late eh?

 

[KenHigg]

Yes.

If you do base it on a query the just add a column and something like the following:

MyNewField: myProcessSheetTime + me]![myProcessSheetTime1

ken

 

[pekuiper]

Thanks I will re-do it and try it. Thanks for your help.

 

[KenHigg]

Thanks I will re-do it and try it. Thanks for your help.

We'll get it to work - hang in there -

ken

 

[pekuiper]

Still doing something wrong - still get the #name?

This is what I have in the new form "DataEntryForm" based off the "DataEntryFormQ" Query:

Adding a text Box:

In the Control Source:

=[me]![myProcessSheetTime]+[me]![myProcessSheetTime1]+[me]![myProcessSheetTime2]+[me]![myProcessSheetTime3]+[me]![myProcessSheetTime4]+[me]![myProcessSheetTime5]

Should something be in the Query itself?

 

[KenHigg]

Sorry for the confusion: Yes, you need to add them in the query, not in the control source of the text box...


ken