[AccessD] Is one time between two other times

On 18 Mar 2005 at 13:19, paul.hartland at fsmail.net wrote:

> To all, I can't seem to figure this out at all, I have a table of which
> one of the fields is a start time.  I need to run a query to see if that
> time is between 07:00 and 19:00 

Times are stored as the fractional part of a DateTime so just check whether 
the fractional part is

       > 7 / 24 and < 19 / 24

>or 19:00 and 07:00.

      > 19 / 24 or < 7 / 24

In sert equal signs as necessary to handle your desired boundary conditions 
(ie exactly 07:0 or 19:0)-- 
Stuart