Udate Dates

[fabiola1]

I'm using Ms access 2003 to diseign a contract system.I have a table where i keep my active contracts.In this table table i have a field called status and a field called expiry date.when a contracts is active it's status is active.What i want to do is when the contract expires i want the code to check curent date and if the expiry date is past the current date it should automatically chang the status to expired.

[MikeTheBike]

I'm using Ms access 2003 to diseign a contract system.I have a table where i keep my active contracts.In this table table i have a field called status and a field called expiry date.when a contracts is active it's status is active.What i want to do is when the contract expires i want the code to check curent date and if the expiry date is past the current date it should automatically chang the status to expired.

Hi

You need to run an update query like this (every day or when the DB is opened?)

UPDATE tblContracts SET tblContracts.Status = No
WHERE tblContracts.ExpiryDate<Date();

??

MTB