Query Expression Help needed...

[daviddenver303]

Hi - I am builing an "Update Query" in Microsoft Access 2002. I am trying to get the query to change the status field of a record to INACTIVE IF the date field has a date 7 days or older from today's date.

Can someone please show me an expression for this?

Thanks a lot

David

 

[raskew]

Something like this:

UPDATE tblEDates SET tblEDates.Status = IIf(DateDiff("d",[eDate],Now())>=7,"Inactive","Active"