Type mismatch in expression. (Error 3615

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I receive the following error whenever I try to open one of my tables in
Access:
--Type mismatch in expression. (Error 3615)
Does anyone know how to fix this? I made sure that all of my joined fields
match. It is preventing me from opening my table in datasheet view.
Thanks for your help.
 
I don't understand what you mean by "open one of my tables" and making "sure
that all of my joined fields match".

If you're opening a table, there aren't any joined fields. If you're trying
to open a query that joins two tables, what's the query?
 
Narrow down the problem by trying to run the query alone that is the record
source for the form.
Any calculated textboxes in the form?
 
To Douglas:
I was trying to open my table in the datasheet view but am unable to. I get
the Type mismatch error message just whenever I try to view the datasheet for
the table (I can open in design view)

To Karl:
The query linked to the table runs just fine. I do not have any calculated
text boxes in the form that feeds into the table. This started after I
changed the criteria from one of the fields in the query from Group By to
SUM. After receiving the error, I changed the query back to the original way
that it was but am still receiving the error. The help received from Access
stated the following:

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.
 
Are you using Lookup fields in your table? Did you change the definition of
the table which your current table is looking up its values in?
 
Back
Top