Assuming that you ProductionDate Field has zero time component and your
StartTime & FinishTime Fields have zero date component, you can use
something like:
.... WHERE ( ( [ProductionDate] + [StartTime] )
BETWEEN ( Date() - 1 + #04:30# ) And ( Date() + #16:30# ) )
Alternatively, the following may be more efficient, especially if you have
indices on the ProductionDate and StartTime:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/5922-query-criteria.html
.... WHERE ( ( [ProductionDate] = Date() - 1 ) And ( [StartTime] >=
#04:30# ) )
OR ( ( [ProductionDate] = Date() ) And ( [StartTime] <= #16:30# ) )
--
HTH
Van T. Dinh
MVP (Access)
"Jessica"
wrote in message
news:6FV7f.17030$Bv6.15569@twister.nyroc.rr.com...
> Hello,
>
>
> I have a query with a Production date, a start time, and finish time
> fields. I want to get records starting from 4:30 yesterday morning to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=5922
> 16:30 today. What would I have to use as a criteria?
>
> Thanks,
> Jess
>