Making Fields Blank

[rhiannonj]

I'm trying to make certain fields that did have data in them now be blank. I created an update query: Field-Marketing Support
Update to: [Marketing Support] = Is Null
Field - Submission Date
Update to: [Submission Date] = Is Null

Instead of leaving the fields blank, for Marketing Support it sets the field to 0 and for Submission Date is sets the field to 12:00 A.M. Marketing support is a combo box (text) and Submission Date is a date field.

Thanks for any help you can give me.

 

[Geoff Codd]

i think you are meant to upate to = Null and not = Is Null

Worth a try

 

[rhiannonj]

Thank you for your reply.

When I type in [Marketing Support] = Null, it automatically changes to Is Null and the equal sign is removed.

Any other ideas?

 

[David R]

Just put Update To: Null, not [Marketing Support] = Null. You already told it what field you're working with.

I just tested this and it works. Use criteria "Not Null" to make it go a little faster.

HTH,
David R

 

[rhiannonj]

Yea!! It worked! Thanks so much! I knew I was making it too hard...as usual.