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

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!
 
N

Niklas Östergren

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
 
A

Arvi Laanemets

Hi

....
Iif(FirstCondition,FirstValue,Iif(SecondCondition,SecondValue,ThirdValue))..
..
 
N

Niklas Östergren

Hm, I missunderstod your q. Sorry!

See answer from Arvi Laanments!

// Niklas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Insert Multiple Fields without Dialog closing between each... 0
Link a text box based on drop down box with four options MS Word 365 0
MS Project Center-Autolink column fields 0
How to display zero value in blank fields of Cross Tab query 0
VBA Coding Help for Beginner 0
Creating a Chart on form from selected data in query. 0

Top