Hi.
I know this is probably really simple but I have no idea how to do. How do I write a formula to find the datediff of someone's hire date and their term date in Access?
If you can help me, I'd certainly appreciate it.
Here is what I've figured out so far: Yrs: DateDiff("yyyy",[LAWSON_EMPLOYEE]![DATE_HIRED],[LAWSON_EMPLOYEE]![TERM_DATE]) and it works sort of. Right now it pulls the number of years based soley on the year so if someone started 7/1/2012 and left 5/1/2013, it shows 1 year. I need it to show as a 0 since they were not here for an entire year.
Thanks!
Edited by VickiM - 16 Aug 2013 at 5:15am