Help! How can i select between 3 values of a field in a query?

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

In a query, if i want to select between 2 values of a field, I am using
"Iff"
If I need to select between 3 values of the field how do I have to do?

I would apreciate any help!
Thank you!
 
How about using <Case>?

Using <Case> instead of <If> or <IIf> you can select as many values as you
like! See helpfile for function <Case>. If you don´t solve it by your self
please get back and I´ll try to help you out!

I hope I understod your Q correct!?

// Niklas
 
Hi

....
Iif(FirstCondition,FirstValue,Iif(SecondCondition,SecondValue,ThirdValue))..
..
 
Hm, I missunderstod your q. Sorry!

See answer from Arvi Laanments!

// Niklas
 
Back
Top