Hi I am quite new to Access and was wondering if someone could help me out with a small issue.
Basically I have a database which keeps reocrds of computer information. One field keeps a record of the warranty expiry date, and another field (warranty status) displays whether it is in warranty or not. At the moment both fields are manually entered but I would like change it so that the warranty status field changes automatically depending on today's date. Ie, if I enter a warranty expiry date of 01/01/2007, then the warranty status field would change automatically to "Out of Warranty".
this is probably a simple thing and can be done with some form of macro, but I am new to building macro's and expressions! Please help!