Hi Chas and Roxanne,
I think this must be one of two things. Either the assumed variables have fields with duplicate names, but are not prefixed with an "m.". If a variable doesnt have the "m." infront of it (m.Variable), if there is a field by the same name (Table.Variable) in the selected area, then it compares the field instead of the variable. Previx all variables with "m." except when assigning them ("x = 4" as opposed to "IF m.x = 4"). The other scenario, and I assume this is probably it. Is just the nature of comparing strings. Do this:

?"abc" = "ab"
?"ab" = "abc"

Other than that, it is best to put WHERE Field = m.Variable because it is Rushmorizeable. WHERE m.Variable = FieldName is not.


Hope this helps