[AccessD] time window

I need to be able to express a pure time window (not date related) from / to
and test time() as being between (inside) this time window.  This process
doesn't work across midnight, i.e. 7:00 pm is "between" 6:00 pm and 1:00 am.
However if I just do a simple compare - 7:00 PM is >= 6:00 PM but it is not
<= 1:00 am.

It looks like a "if time 2 > time 1 then use simple test for time()"  "If
Time 2 < time 1 then invert the second time comparison"

Has anyone done this already?

John W. Colby
www.ColbyConsulting.com