I think you can insert a NULL value into the field if it's not required. Do something like:
INSERT INTO yourtable (StartTime) VALUES ( <cfif len(FORM.StartTime)> '#FORM.StartTime#' <cfelse> NULL </cfif> ) _____________________________ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 5:05 PM To: CF-Talk Subject: time field in access I have an Access db with a date/time value with a medium time format (0:00 am). The field is set as not required. When the form is left blank for the time value and the query insert is attempted you get StartTime '' But then you get the error message: data type mismatch in criteria expression How do I insert an empty value or a null value into that date/time field? Sebastian ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
