data type mismatch in criteria expression when no criteria specified

[JR]

I get ERROR 3464 (data type mismatch in friteria
expression) on a query where I have not specified any
criteria.

The problem seems to stem from one column in one of three
tables (Table 3 of 1,2,3 -- relationships between tables 1
and 2, and 2 and 3, not 1 to 3) used for query. The
column has only two possible values in it: SWA and NNA.
If I do specify a criteria for NNA the query runs, if I
specify SWA the query does not run. If I specify
either "and" or "or" the query does not run.

IF I add another, older version of one of the tables with
the two possible entries, create a relationship from table
2 to this old table (3b) that mirrors the relationship
from table 2 to table 3, then the query runs!

Does anyone have any insights into what may be happening?

Thanks!

JR

 

[John Vinson]

I get ERROR 3464 (data type mismatch in friteria
expression) on a query where I have not specified any
criteria.

The problem seems to stem from one column in one of three
tables (Table 3 of 1,2,3 -- relationships between tables 1
and 2, and 2 and 3, not 1 to 3) used for query. The
column has only two possible values in it: SWA and NNA.
If I do specify a criteria for NNA the query runs, if I
specify SWA the query does not run. If I specify
either "and" or "or" the query does not run.

Please post the SQL view of the query. What are the datatypes of the
relevant fields? Do you have any <yuck, PTOOIE!> Lookup fields (which
cause this kind of error by concealing the actual numeric content of
the field behind a looked-up text value)?