Expression help please

T

TKM

I need to know how to make an expression that will not show results based on
my expression. Such as..
I need to base it on my ([LoanProgram]) field and if the number "10" is in
the field name "Conditions" then do you not show the results for that number
and go on to the next "condition" such as 11, 15 (I will put the numbers in)
however I don’t know how to write this so it will work. Please help!
 
T

TKM

I forgot to mention that This expressionis based on a loan numbe rif that
makes any difference. Such as if, the number started with a 04 then it would
apply to the expression if it started with a 22 then it would not.

Thanks in advance
 
J

John W. Vinson

I need to know how to make an expression that will not show results based on
my expression. Such as..
I need to base it on my ([LoanProgram]) field and if the number "10" is in
the field name "Conditions" then do you not show the results for that number
and go on to the next "condition" such as 11, 15 (I will put the numbers in)
however I don’t know how to write this so it will work. Please help!
Click to expand...

Please post a description of your LoanProgram and the Conditions field. It
sounds like you are violating the principle that fields should be "atomic" -
if the Conditions field contains multiple conditions in the same field, YOUR
DESIGN IS WRONG. Each field should contain one and only one value.

John W. Vinson [MVP]
 
Top