Updating a date field to be blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Working with a club membership data base. I use an Action Query to update the member status code and dates for 1st & 2nd notices. When the member pays the dues, the Code is changed from "R" (Renewal) to "C" (Current) status. At the same time, I would like to clear or empty the 1st Notice and 2nd Notice date fields since they are no longer necessary after the Renewal. How can I clear the date fields to be empty after the update?
 
Dates are actually stored as numbers, so you can't set them to blank. You
can set them to Null, though, if you want.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Ray Murray said:
Working with a club membership data base. I use an Action Query to update
the member status code and dates for 1st & 2nd notices. When the member pays
the dues, the Code is changed from "R" (Renewal) to "C" (Current) status. At
the same time, I would like to clear or empty the 1st Notice and 2nd Notice
date fields since they are no longer necessary after the Renewal. How can I
clear the date fields to be empty after the update?
 
Back
Top