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

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

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.

check out http://support.microsoft.com/default...roduct=acc2000


Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com