Need Help

[Tragac011]

I just beging learning access and I have some problem with IIF function

IIf[Broj dana]<=20>=15,5,0,IIF[Broj dana]>=20,10,0))

I need something like this

If someone can help , please

 

[jdraw]

IIf([Broj dana]<=20 and [Broj dana] >=15,5,IIF([Broj dana]>=20,10,0))

You have 2 results for [Broj dana] =20????????

 

[Tragac011]

IIf([Broj dana]<=20 and [Broj dana] >=15,5,IIF([Broj dana]>=20,10,0))

You have 2 results for [Broj dana] =20????????

Yes Its depend . That is difference between two dates

If tthat number is betweeen 15-20 then I need 5
If greater than 20 i need 10

 

[Frothingslosh]

Here you go:

IIf([Broj dana] > 20, 10, IIf([Broj dana] >= 15, 5, 0))

That is the formula version of this:

Yes Its depend . That is difference between two dates

If tthat number is betweeen 15-20 then I need 5
If greater than 20 i need 10

 

[Tragac011]

Here you go:

IIf([Broj dana] > 20, 10, IIf([Broj dana] >= 15, 5, 0))

That is the formula version of this:

Thank You very much

 

[Kitoned]

Originally Posted by Tragac011
IIf[Broj dana]<=20>=15,5,0,IIF[Broj dana]>=20,10,0))

Try this:
IIf([Broj dana] Between 15 And 20,"5", IIf([Broj dana] >=20,"10","0"))

Note: I do not know how to code IIf([Broj dana] Between 20 And "Infinity"

 

[Frothingslosh]

Note: I do not know how to code IIf([Broj dana] Between 20 And "Infinity"

That's just another way of saying 'greater than'.