What expression to use to get multible results

  • Thread starter Thread starter rlholland
  • Start date Start date
R

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.
 
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".
 
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
 
Back
Top