...........
>>What is your SET ANSI?
>>>
>>>Using == does force a .f. I cannot use UPPER() since I want the upper and lower
>>>case to be a different key.
>>>
>>>Is there a "Set equal to approximate" checkbox somewhere that I need to find?
>>>
>>>Don
>
>
>Load the 2 var names in the debug window. Are you sure there taking the values your storing. My only thought is that you have a field name with the same name as one of your variables.
>
>HTH

I am actually forming a query. When I run the query I have it include drawing_id from both files
(the cross reference file and the drawing file). They are different as indicated. I can run

count for not drawing_id == drawing_i2

and get a tally of the number of incorrect matches the query produced.

Setting ANSI on or off does not affect the result.

Using the "==" double equal in the SQL statment does not help either.