Update blank date field automatically

  • Thread starter Thread starter Chris
  • Start date Start date
C

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.
 
Hi,


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




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top