Sure. I am actually attempting an insert - not an update. I realise the use
of my delimiters is probably incorrect, however besides date time I usually
have no problem using these delimiters. My other update statements are
working fine but this particular insert is causing problems....my sql
statement falls apart if I remove the single delimiters (txt only)....
ActualClosingDa te=Request.Form .Item("ActualCl osingDate")
If len(trim(Actual ClosingDate)) > 0 then
ActualClosingDa te=ActualClosin gDate
Else
Response.Write "******"
ActualClosingDa te = Null
'ActualClosingD ate="00/00/00"
End If
SQL=SQL & "'" & ActualClosingDa te & "'," '#32 - date/time
SQL=SQL & "'" & SellingCommissi on & "'," '#33 - number
SQL=SQL & "'" & ListingCommissi on & "')" '#34 - number
Response.Write "<br>" & SQL & "<br>" & Active
'response.end
cnn.Execute(SQL )
"Aaron Bertrand - MVP" <aa***@TRASHasp faq.com> wrote in message
news:ey******** ******@TK2MSFTN GP10.phx.gbl...
I need to deposit and empty dummy value into a date/time field within
Access using INSERT. However, I pick up a data type error if I attempt to
insert a NULL value for this particular date time field....
Can you show the syntax and the actual error message? Narrative is very
difficult to debug.
Did you try
UPDATE table SET dateCOLUMN = NULL WHERE [...]
Notice that null is not in quotes or # delimiters, it's just a lone
keyword...