Okay, I should be able to figure this out, but I haven't been able to:
Trying to create a formula field in an access query that basically gives me length of term of service of an employee, by taking current date (TODAY or NOW?), subtracting hire date(hire date field in the employee table), and then dividing that answer by 365. I have tried several options, but never get the result I want, so apparently I'm writing it wrong.
Can you help?