Can you put an IF statement in a query expression?

J

Jimbo213

How can I create this expression in a query

FITOK: =IIF(OR( [Status_FIT_Lead]=75,[Status_FIT_Mult]=0),"OK","No")

Thanks for your reply & assistance.
Jimbo213
 
J

John Spencer

FITOK: IIF( Status_Fit_Lead = 75 OR Status_Fit_Mult =0,"OK","No")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
J

Jimbo213

OUTSTANDING - - - - worked the first time.

Thanks for your reply & assistance, John
Jimbo213


John Spencer said:
FITOK: IIF( Status_Fit_Lead = 75 OR Status_Fit_Mult =0,"OK","No")

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

How can I create this expression in a query

FITOK: =IIF(OR( [Status_FIT_Lead]=75,[Status_FIT_Mult]=0),"OK","No")

Thanks for your reply & assistance.
Jimbo213
Click to expand...
Click to expand...
 

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

Access Query problem 1
iif statement and defining calculated expression once only 1
Parameter Query on an expression 8
If Statement with "*" in Query 2
Access My Expression Contains Wrong number of arguments 0
Expression Builder query with zero amounts 5
Date expression in Query 4
Error in IIf Expression 5

Top