I am currently drawing up a database for contractor management. We have to keep an eye on when these contractors were inducted. The max term of an induction is 1 year. I have built a database and everything works EXCEPT when I want it to calculate the number of months between the date of their induction (from an access db file) and todays date. I get an error message indicating that the access db date cannot be converted.
Can anyone please advise me on how to overcome this problem?