Can you put an IF statement in a query expression?

  • Thread starter Thread starter Jimbo213
  • Start date Start date
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
 
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
'====================================================
 
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...
 
Back
Top