I'm new to Access and having problems using dates in calculations...
I want to use these in a form :
Date Field: Date()
Date Of test: "Date Field"
Date of Next Test:"Date of Test" + 180 days
Days Overdue: Date() -"Date of Next Test"
I've tried to work it out using expressions, but don't think I'm grasping the syntax....I come from the simple world of the Approach database where you can create calculated fields in the table...
Any help, guidelines, clues greatly appreciated