What expression to use to get multible results

[rlholland]

Hope someone can help. I'm not very good at these.
I have a query that shows how many days the employee has been there. From
that I need an expression that shows if <365 day then 0, >=365 and <1825 then
5, >=1825 and <3650 then 10 >=3650 and >7300 then 20.
I'm not sure what I need to use to get how many vacation days the employee
has per year and make sure that it changes with the date.

 

[Dorian]

You can use the IIF function.
Look it up in Access help, basic syntax is
IIF(condition,action if true,action if false)
You will need several nested IIFs to handle your situation.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[rlholland]

Thanks for responding. I have looked in the help but can't figure out hou to
use so many different results. I you can please give me an example I would
be grateful.
Thanks
rlholland