Creating a Time Sheet Entry Form in Access

[TXDalessandros]

I have never had to use a form/subform in access before. I am guessing this
is the correct way to go about this. I will have users entering the
following data

I have the following field being enter only once in the main form
The date is a default value of Date()
The Employee name is a lookup field from a table.

Subform then contains the following:
Activity-lookup field (task name)
Start Time
End Time

after each line I want the activity time to be calculated (End Time-Start
Time)
and then I would like a total time for that day.

Not sure the best way to go about accomplishing this

Thank you

 

[Gina Whipp]

TXDalessandros,

Some place to start, this comes up quite often here....
http://groups.google.com/group/comp...?q=time+calculations&start=10&sa=N&scoring=d&

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[TXDalessandros via AccessMonster.com]

But how do I have the date and time only entered once and then have the (I
guess subform) show the activities individually and then total time for each
activty and total the time for the date all on the same for as the user
updates it

TXDalessandros,

Some place to start, this comes up quite often here....
http://groups.google.com/group/comp...?q=time+calculations&start=10&sa=N&scoring=d&

I have never had to use a form/subform in access before. I am guessing
this

[quoted text clipped - 17 lines]

Thank you

 

[Gina Whipp]

You say the date only once but in yor earlier posting you said you have a
Start Time and End Time, so I am not sure what you mean by the date only
entered once???

That being said, have you set up your forms yet? If not, lets get those set
up so we can work on getting you the totals you want. If you are unsure if
your table set up will not accomodate what you want to do post your table
set up. Afterall, we MUST get the foundation set up BEFORE we build the
house on top!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

But how do I have the date and time only entered once and then have the (I
guess subform) show the activities individually and then total time for
each
activty and total the time for the date all on the same for as the user
updates it

TXDalessandros,

Some place to start, this comes up quite often here....
http://groups.google.com/group/comp...?q=time+calculations&start=10&sa=N&scoring=d&

I have never had to use a form/subform in access before. I am guessing
this

[quoted text clipped - 17 lines]

Thank you