View Single Post
  #1 (permalink)  
Old March 23rd, 2006, 12:34 PM
deepcover1 deepcover1 is offline
Registered User
Join Date: Feb 2006
Location: , , USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Calculate total hours based on Time

I have a created a “Daily Attendance Record” called tblsDAR. Within the table I have created the fields:

DaysoftheWeek(DOW), i.e, Mon, Tues, etc…
Date: 99/99/0000;0;_
Time1: In 99:00\ >LL;0;_
Time2: Out 99:00\ >LL;0;_

My issue is this, When a client record is entered, I am able to enter the TimeIN and TimeOut. Such as in increments of the ¼ hour, ½ hour or a full hour. For example I enter the record for:

Clientname: Bob Jones
DOW: Monday 03/22/2006
Time1: Time In 8:45am
Time2: Time Out 1:00pm

This is done for the week. I want Access to “calculate” the Total Units of Service for the week or to return the sum value based on the TimeIN/TimeOut field(s).

Any help is definitely appreciated.