p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Calculate total hours based on Time (http://p2p.wrox.com/showthread.php?t=40278)

deepcover1 March 23rd, 2006 12:34 PM

Calculate total hours based on Time
 
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.


AccessMaster April 5th, 2006 01:50 AM

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


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


All times are GMT -4. The time now is 03:05 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.