Using ElseIIF and Between functions together 1

[BrianKconner]

I am trying to create a formula in a query that will test the value range of another field and assign a value to the expression field.
For example:
=IIF( [ATB]![AGE] =BETWEEN 0 AND 30,30) ESLEIFF( [ATB]![AGE] =BETWEEN 31 AND 60,60.
Any help would be greatly appreciated......

 

[lars7]

You have spelt else wrong.

 

[PHV]

IIf(ATB.AGE Between 0 And 30, 30, IIf(ATB.AGE Between 31 And 60, 60, 999))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886