It is a Paradox 4.5 data base. My "feel" is that it has do with the # character, because if I use any of the other two key fields that do not have the # character, it works just fine. The only trouble is when I use the particular field name [Contract #], even if I add it to the query that is working with the other 2 key fields.

Seems like I remember that if I import this table in to Access, it converts the # in the field name to a period. Does this have implications on my query?

Also, if I want to SELECT all records that have no value for [Contract #] do I query for [Contract #] = NULL?

Thank you,
John