Change field by Date

  • Thread starter Thread starter McCoy
  • Start date Start date
M

McCoy

Hello

I have a table where each record has a field containing a date and a
field containing status. I would like all the records older than 1 month
to whose current status is "Quote" to change to "Outstanding"
automatically when i open the application. Some kind of a ok/cancel
prompt would be useful.

There are also other values in the status field such as "Accepted" and
"Rejected", I would like any record with these values to remain unchanged.

I am new to microsft access and any input would be greatly appreciated.

Thanks in advance

Daniel McCoy
 
Hi
I'm also new to access. But i think a table won't give you
dynamic data. Maybe you'd try using a query with
calculated field to achieve that.
 
Back
Top