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
Click to expand...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear a date field using a macro 12
VB Code to change Access Form field visibility for that record only 1
Date as a value to a textbox as a result from another textbox 1
Renewing member database design question. 7
Access MS-ACCESS 2010 - Date Stamps 13
A Brexit Story 1
Payment Dates in Access 2007 0
Cascading combos in datasheet 0

Back
Top