Tried that and it did not clear the date fields. Also tried the "" entry and was not able to clear the date fields either. Thanks...I'll try them again and see if I did something wrong the first time. Dave
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Gary E. Daniels Sent: Tuesday, March 28, 2006 10:37 PM To: [email protected] Subject: Re: [ms_access] Re: Update query I think you just type Is Null or IsNull. Gary At 04:14 AM 3/29/2006 +0000, you wrote: >have you tried "" (open and closing quotes) > >--- In [email protected], "Dave Moreau" <[EMAIL PROTECTED]> wrote: > > > > What is the correct way to update a date field back to null with >an update query? I can not figure out what to put in the update >line for > > > > Dave > > > > Gary E. Daniels Cornerstone Appraisal Company 500 Selkirk Drive Schaumburg, IL. 60194 847 882-5892 Fax 847 882-5963 mailto:[EMAIL PROTECTED] http://www.askdata.net _____ YAHOO! GROUPS LINKS * Visit your group " ms_access <http://groups.yahoo.com/group/ms_access> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . _____ This e-mail and any attachments may be confidential or legally privileged. If you receive this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
