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.

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

Worth a try

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?

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

Yea!! It worked! Thanks so much! I knew I was making it too hard...as usual. http://www.access-programmers.co.uk/ubb/smile.gif