Global Updating of Dates

[shuff]

Sheesh! This seems like a simple question, but I don't know the answer. If I have a pair of fields, such as Score and ScoreDate, and some records have no score but DO have a score date because of a previous global modify, how do I globally modify these records to blank out the date when the Score field is null? Put another way, IF [SCORE] Is Null, THEN UPDATE [SCOREDATE] TO {Blank/Null}.

Thanks,
SHuff

 

[Fornatian]

Use an update query with the criteria and update values as per your question...

Score: Null
(Update Value) ScoreDate: Null

 

[shuff]

Worked Great!!

Simple question, simple solution. Thanks.

Somehow, I've managed to use Access for six years and never have need to set a date field to Null.

SLH