Expression help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Expression used in a table 2
Conditional Expression on automatically populated field 1
Count records with condition... 1
check box with required fields 3
DLookup and Nz 0
Recordset is not updatable 3
Expression help 1
Access Macro Repeat Expression using value of a field in table 0

Back
Top