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?