=========================================
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
=========================================
With Access and SQL, you put the NOT before an otherwise true condition.
WHERE NOT StartTime BETWEEN 1899-12-30 18:00:00 AND 1899-12-30
18:30:00
---mark
-----Original Message-----
From: Skyward Internet Technology [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 9:52 AM
To: CF-Talk
Subject: (OT) Access SQL Statement
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
