Error 3615

[Lucien]

I am getting the following error when trying to execute a query:

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.

I imported a table from an Excel spreadsheet that I have linked to an
existing table. I think this is where the problem is, but how do I fix it?

thanks,
Chris

 

[Arvin Meyer [MVP]]

To resolve the problem, first identify the join that's causing the problem.
I do that by makeing several copies to the query and eliminating the joins
until I find the one that causes the error. Then either change the datatype
in the table or build a query which converts the datatype of a column

Example: CStr([MyField])

Build a second query which joins on the results of the first.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Wayne Morgan]

Open the imported table in design mode. Go to the field you are trying to
make the join on and see what the Data Type for that field is. Open the
other table in design mode and see what the Data Type is for the field that
is the other side of the join. They both need to be the same. Adjust the
imported table as needed.

 

[Lucien]

Ok, I found the join that is the problem. In my imported table the data type
for the field is Number. I need to adjust it to Text so it will match my
other table. How do I do that?

 

[Wayne Morgan]

Open the table in design view. Place the cursor in the field that's the
problem. Change the data type in the 2nd column to Text. In the bottom part
of the window, make sure that Field Size is at least as large (larger is ok)
at the longest data in the field (for a text field this would be the record
with the greatest number of characters). Click Save and close the table.

 

[Lucien]

This worked great.

Thank you for the time.

Open the table in design view. Place the cursor in the field that's the
problem. Change the data type in the 2nd column to Text. In the bottom part
of the window, make sure that Field Size is at least as large (larger is ok)
at the longest data in the field (for a text field this would be the record
with the greatest number of characters). Click Save and close the table.