I imagine this is FM101, but here goes. The following scripted find works if I use "=" (but with different effect, of course), but when I use "≠", I get unexpected results (I get records with two fields that both are equal and not equal.)

Doesn't work as expected (I'm trying to end up with a found set of records where the value of two fields match):

fieldA and fieldB are number fields.

Perform Find [Restore] [Find all records with a non-null value for fieldA - this step works]

Go to Record… [First]

Loop

If [table::fieldA ≠ table::fieldB]

Omit Record

End if

Got to Record… [Next; Exit after last]

End Loop

Thanks, Ken

Edited November 16, 200916 yr by Guest

Finds don't work that way, because it would require the find request to be different for each record. It's essentially putting dynamic criteria that depends on each individual record.

Create a calculation field with the expression fieldA = fieldB. Th result of the expression will be either 1 or 0. Now perform the find in the calc field for zero.