[AccessD] Is one time between two other times

paul.hartland at fsmail.net paul.hartland at fsmail.net
Fri Mar 18 06:19:32 CST 2005


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 or 19:00 and 07:00.

Can any help me with this please.

Thanks in advance for your help.

Paul Hartland

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm


More information about the AccessD mailing list