Formula

[Loi]

Hi,
I have a table which has CHECKINTIME and CHECKOUTTIME
fields. May I create a query that will show TotalTime
check out?

For example:
CheckOutDate CheckOutTime CheckInDate CheckInTime
10/21/04 8:30 am 10/22/04 10:30am.

Total time that I counted out by myself is 26 hours or 1
day 2 hours.

Please show me how to create query which shows a TOTALTIME.

Thank you very much
LOI

 

[John Vinson]

Hi,
I have a table which has CHECKINTIME and CHECKOUTTIME
fields. May I create a query that will show TotalTime
check out?

For example:
CheckOutDate CheckOutTime CheckInDate CheckInTime
10/21/04 8:30 am 10/22/04 10:30am.

Total time that I counted out by myself is 26 hours or 1
day 2 hours.

Please show me how to create query which shows a TOTALTIME.

Put

DateDiff("h", [CheckInDate] + [CheckInTime], [CheckOutDate] +
[CheckOutTime])

in a vacant Field cell in a query.

Note that an Access Date/Time field is stored internally as a Double
Float count of days and fractions of a day (times) since an arbitrary
start point; as such it's usually better to use a single date/time
field (CheckInDateTime say) rather than separate date and time fields.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps