Updating a date field to be blank

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?
 
D

Douglas J. Steele

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

Poor table design? 16
query based on a date field 2
My table field is not being populated 4
Need to clear date field 3
Filtering on a user-defined date field 7
Query with multiple date fields 1
Updating from Form to Table (Mulitple fields) 3
automatic update to a field (Date/Time) 2

Top