help with expression please

  • Thread starter Thread starter Cheryl Larson
  • Start date Start date
C

Cheryl Larson

Hello. Writing an expression on a field in a report and I need to look
for three (as an example) distinct values in this field. If any of the
three values are there, return "NA" on the report. Otherwise, return
the actual field contents. This is what I have in the Control Source
for the field in my report:

=IIf([Current Indicators.LIST.Index]="PHY1","NA",[Current Indicators.SIP
Compliance])

This works perfectly for ONE value. How do I get this working for more
than one value (like "PHY1" "PHY2" and "PHY3"? Thank you.
 
try

=IIf([Current Indicators.LIST.Index]="PHY1" Or [Current
Indicators.LIST.Index]="PHY2" Or [Current
Indicators.LIST.Index]="PHY3","NA",[Current Indicators.SIP Compliance])

or

=IIf([Current Indicators.LIST.Index] In ("PHY1","PHY2","PHY3"),"NA",[Current
Indicators.SIP Compliance])

i'm not sure if *In* will work in this expression, though.

hth
 
"In" worked beautifully. Thank you so much for your help!
try

=IIf([Current Indicators.LIST.Index]="PHY1" Or [Current
Indicators.LIST.Index]="PHY2" Or [Current
Indicators.LIST.Index]="PHY3","NA",[Current Indicators.SIP Compliance])

or

=IIf([Current Indicators.LIST.Index] In ("PHY1","PHY2","PHY3"),"NA",[Current
Indicators.SIP Compliance])

i'm not sure if *In* will work in this expression, though.

hth


Hello. Writing an expression on a field in a report and I need to look
for three (as an example) distinct values in this field. If any of the
three values are there, return "NA" on the report. Otherwise, return
the actual field contents. This is what I have in the Control Source
for the field in my report:

=IIf([Current Indicators.LIST.Index]="PHY1","NA",[Current Indicators.SIP
Compliance])

This works perfectly for ONE value. How do I get this working for more
than one value (like "PHY1" "PHY2" and "PHY3"? Thank you.
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

Dealing with NA response 1
Formating the output of report's TextBox 6
Unusual Calculation in Report Header 1
Expressions that Return "#Num!" 6
Multiple expressions 1
Change text box background color depending on value in Label Reports 1
Problem with IIF statement 5
Show zero value but hide NA 3

Back
Top