Folks
I'm working on a Travel and Expenses system and trying to come up with a solution to the following. Company has three bases. Company policy dictates that if departing from home to work at a location not your base, then you should clain the smallest distance between either Home - Work or Base to Work. So for example:
Employee A
Lives 6 miles from Office A. He is based at Office B.
Distance between Office A to Office B is 10 miles.
He travels from Home to Office A and therefore should claim 6 miles but claims 10.
Employee B:
Lives 12 miles from Office A. She is based at Office B.
Distance between Office A to Office B is 10 miles.
She travels from Home to Office A and therefore should claim 10 miles but claims 12.
I know it's a relatively simple if statement but I cannot figure out how or where to integrate it. I have a Staff Table and a Claim Table. Happy to attached if necessary.
Thanks for any assistance provided.
Frank