INIALIZE DATE FIELDS IN A RECORD

[JoeVegas]

In each of my records I have 6 date fields using the format:08/13/2002. I need to initialize the entire table recordset (date fields only), following a copy of the table to archive. How can this be done using Access 2000 VBA?
TIA....

 

[cmmrfrds]

What do you mean by initialize, make the dates null or zero. What should be in the date field after it is initialized.

 

[JoeVegas]

I guess you would say NULL. The date fields will retain their formatting for a short date so that new dates can be entered again, then copied to archive and again date fields initalized to null? for use again.

 

[cmmrfrds]

You should be able to update the date to the keyword NULL.


update yourtable
set date = NULL
where id = something

 

[JoeVegas]

Thanks, I will try that. As I recall I tried an update query with a criteria IS NOT NULL to capture all the assigned date fields but the result was an error denoting NULL's do not apply to date fields.