Access 2000 Question


J

JER Labrat

I am trying to run a query from my database and I keep getting the message:
Type mismatch in expression. I've checked the help on this which gives me
this: Type mismatch in JOIN expression. (Error 3615) A JOIN expression is
attempting to join two tables on fields of incompatible data types. For
example, you will get this error if you attempt to join a Memo field with a
Text field. But I can't find where the data was incompatible and how to fix
it (relationships, design view, query table, etc.?). If any one can help, it
would be appreciated.
 
Ad

Advertisements

J

John W. Vinson

On Wed, 11 Feb 2009 15:59:00 -0800, JER Labrat <JER
I am trying to run a query from my database and I keep getting the message:
Type mismatch in expression. I've checked the help on this which gives me
this: Type mismatch in JOIN expression. (Error 3615) A JOIN expression is
attempting to join two tables on fields of incompatible data types. For
example, you will get this error if you attempt to join a Memo field with a
Text field. But I can't find where the data was incompatible and how to fix
it (relationships, design view, query table, etc.?). If any one can help, it
would be appreciated.

One way this could happen is if one of the tables contains a Lookup Field and
you're attempting to join on it. A lookup field is actually a (concealed) Long
Integer number, and if you try to create a query joining it to a Text field it
will give this error. It LOOKS like it should work, since you see the text in
your table - but the text isn't really there. Just one of many disadvantages
of the Lookup Field.

If that's not it, please post more information about the tables involved
(fieldnames and datatypes) and indicate what you're trying to join.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top