MattHal

Excellent. Thank you very much for the help. All works exactly as I wanted it to.

Wow, that was too simple (putting the fields as Calculations instead of Text or Number or Date). In the code you show, what does period stand for? I have a similar calculation done up, but Im just wondering why you added period?

In the Storage tab, Use Global Storage is not selected. I'm not sure what Indexing is (it is in the Storage tab also). In Indexing, I have selected NONE and I have also selected AUTOMATICALLY CREATE INDEXES AS NEEDED. Any other ideas?

I am creating a database for calibration of instruments. The instruments need to be calibrated every 1, 2 or 3 years depending on the instrument type. I want to have a field that will display "DUE within 60 days" when an instrument is due for calibration in the following 60 days. Another field would display OVERDUE if the instrument is not calibrated by its due date. I have tried creating a field that contains the current date using Get (CurrentDate). Then using this field in calculations to prompt the given messages but this does not seem to work. Could anyone show what calculation I should be using or is their is a simpler way of achieving this operation? Any help would be greatly appreciated.