Update Query Questions

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

How do I update a "date" field to be empty.

I tried ""
and I tried ##
and I tried #""#

No luck.

Also

How do I update a check box (Yes/No) to be "UnChecked"?

Any help here will be appreciated.

Thanks in advance
Dave
 
For the date field you might try Is Null
For the check box, 0 is unchecked and -1 is checked so if you load them with
zeroes they will be unchecked.
 
"Is Null" did not work but "Null" did.

Thanks

I used "False" on the check box and that seemed to work.

Thanks much

dave
 
Back
Top