Change "expired" to todays days. (01/01/03 format)

[Mike]

Hi, I have a table with a date field. Some of the entries
have 'expired' in them. I would like to write a query to
display the table, and substitute the 'expired' with the
current date. Any thoughts?

 

[Tom Ellison]

Dear Mike:

Sounds something like this:

IIf(ColumnName = "expired", Format(Now(), "Short Date"), ColumnName)

Replace ColumnName with your actual column name.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts