Deleting Selected Fields based on Criteria in Query

[gal4y]

I have a query based on a form.
I have a Check_box that if check for all records of that query, I would like to delete the datefield (make it null) and then reset the check_box field. Can this be done.

I am running an append query prior to this so I don't lose data.

Thanks

Greg

 

[Transcend]

Are you saying that you want to make the date in a row null if the row meets certain criteria?
If so you need an update query.

Transcend