SQL UPDATE, settting TIME to NULL

[John Cosmas]

I have a table containing a field in which I need to set the time to a NULL,
or rather to blank it out. How would I structure my SQL statement using the
DOCMD.RUNSQL to accomplish this?

Thanks
John

 

[Guest]

Try:

UPDATE TblName SET TblName.DateFieldName= Null;

 

[aaron.kempf]

are you talking about a datetime field?

update mytable set thisdate = cdate(cint(thisdate-.5))

hope that helps

-Aaron