Not equal doesn't show correct data

[jambdw]

In Record Selection is the following:

{PA_Smart_Chart_Attac.Attach_User_Sub_Type}="Admission Agree"

and returns correct results. But:

{PA_Smart_Chart_Attac.Attach_User_Sub_Type}<>"Admission Agree"

does not return the correct results

What should I look at to figure out why not?

 

[lbass]

Please show some samples of incorrect results when you use the <> formula.

-LB

 

[lbass]

Also, do you want nulls to be returned? You would have to explicitly select them, as in:

(
Isnull(type) or
trim(type)=”” or
Ucase(Type)<>”ADMISSION AGREE”
)

I added a check for case also and blanks, also

-LB

 

[jammbdw]

The incorrect results are that records where {PA_Smart_Chart_Attac.Attach_User_Sub_Type}="Admission Agree" appear when the {PA_Smart_Chart_Attac.Attach_User_Sub_Type}<>"Admission Agree" is used in the selection.
Case would not be a factor as I select the entry from "Browse data" when creating the selection and variances in the data entered in the field are not allowed.

 

[lbass]

Then. I wonder whether your selection formula is at fault. Do you have an “or” clause somewhere? Please post the full selection formula.

-LB