I'm used to Oracle, so I always choke on Access stuff . . .
How do you do a NOT BETWEEN in Access?
(Note: StartTime is a Date/Time Field)
EX:
SELECT StartTime
FROM myTalbe
WHERE StartTime NOT BETWEEN 1899-12-30 18:00:00 AND 1899-12-30
18:30:00
ORDER BY StartTime
Thanks,
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
