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

<*> 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/
 



Reply via email to