Change the start and end hours in a date

[Guest]

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

 

[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

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.