Share via

Type Mismatch in Expression? Microsoft Access 2013?

Anonymous
2016-04-14T18:00:10+00:00

I have no idea what this is. I'm trying to make a query table and when I attempt to run it, it says "Type Mismatch in Expression". I have no idea what this means

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DBG 11,531 Reputation points Volunteer Moderator
    2016-04-14T19:32:29+00:00

    Can you post the complete SQL statement of your query? Thanks.

    0 comments
  2. ScottGem 68,780 Reputation points Volunteer Moderator
    2016-04-14T19:38:27+00:00

    My guess is that your join between the donations and donors tables use different datatypes. The Screen shot doesn't show the tables or the join fields so we can't tell you what fields to check.

    0 comments
  3. Anonymous
    2016-04-14T19:50:03+00:00

    I suspect that when designing the Donations table you used the lookup field wizard to set the data type of a Donor column or similar, and that when creating the query you have attempted  join the tables on the foreign key Donor column in Donations and a non-key Donor column in Donors rather than on the primary key DonorID or similar column in Donors.

    This is a good example of why the lookup field wizard should be avoided like the plague.  For reasons why see: http://www.mvps.org/access/lookupfields.htm.

    0 comments