Got it....I was using isnull which made the entry a text string....when I used Null only it eliminated the data in both the time and date fields with no problem. thanks 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/
