Type mismatch

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Trying to make aquery drawing on two tables. The tables
are linked to external dat (.xls). When I try to view the
query in table view or try to export the data, I get the
error message "type mismatch in expression". There are no
expressions in the query, only field names. There are no
type mismatches in any of the fields. Tried eliminating
all fields but one, still get the message! Is this a bug?
wasn't doing it before. If Access is going to give an
error message, it ought to at least tell you where it is-
if there is an error. Would appreciate any advice. This
problem makes Access impossible for me to use.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When you get a type mismatch on joined tables, it is usually a
mismatch on the join columns. E.g.:

SELECT t1.* FROM t1 INNER JOIN t2 ON t1.c1 = t2.c1

If t1.c1 is not the same data type as t2.c1 the Mismatch error will
occur.

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBBBR4echKqOuFEgEQLn8QCgte/4CgMKSWXPj2qn7y9YJGwwCLMAoO9p
PY1+5+ChhiEc2lZdw81We/6d
=dlsF
-----END PGP SIGNATURE-----
 
Back
Top