Change the start and end hours in a date

D

Don

Criteria in a query:
I need to calculate days using 07:00 as the start of day and 07:00 (next
day) as the end of day.
Specifically to calculate sales in a Pub where sales may exceed 24:00 and
not exceed 07:00 the next day
 
R

RuralGuy

You can use DateAdd("h",-7,[YourTimeField]) to adjust your records by -7 hours.
Criteria in a query:
I need to calculate days using 07:00 as the start of day and 07:00 (next
day) as the end of day.
Specifically to calculate sales in a Pub where sales may exceed 24:00 and
not exceed 07:00 the next day
Click to expand...
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Top