Negative results

[oxicottin]

Hello im getting a negative result what and where am I missing in the formula?

IIf([YearsOfService]<=0,0,IIf([YearsOfService]<=1,1,IIf([YearsOfService]<=7,2,IIf([YearsOfService]<=14,3,IIf([YearsOfService]<=24,4,IIf([YearsOfService]>=25,5))))))

 

[smig]

At the end you have if with nothing in the True or False results. So I guess you simply get False as the final result.

Use Select Case.

 

[oxicottin]

smig, its a query expression so how could I use select case?

 

[jdraw]

,IIf([YearsOfService]>=25,5,??))

You need something here!

 

[smig]

smig, its a query expression so how could I use select case?

Create a function and put the select case in it.

It will make your code much more reaadable.