Update blank date field automatically

[Chris]

I have this SQL statment:
WHERE([Resultls of investigation].[date of reply]+14>=Date
() And [Results of investigation].[Date of close out]is
Null);

Basically this statement returns blank records for the
field [date of close out] 14 days after the reply was
sent. What I would like to do now is to be able to fill
these records in the [Date of close] out field with the
current date. Is it possible to add to my sql statement to
achieve this?

Thanks a lot,
Chris.

 

[Michel Walsh]

Hi,


UPDATE tableName
SET [Date of close] = Date( )
WHERE ....




Hoping it may help,
Vanderghast, Access MVP