>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?
>

I suppose it will no longer work if you use [Contract .] as opposed to [Contract #]. You would have to adjust for that in the query. Is this a valid character for a paradox field name?

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

It depends on what is the syntax for the paradox SQL. ANSI SQL standard checks for nulls like so: WHERE [Contract #] IS NULL. If this is not supported then the paradox SQL reference should give you an answer, as I am not familiar with it.

>Thank you,
>John