Change the start and end hours in a date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top