Error Code: 13
Error Source: VBA
Error Message: Type Mismatch

A procedure/query/lookup is expecting a particular datatype, but receives a different one

Possible Causes and Resolutions

Criteria in a query doesn't match the underlying table fields datatype. If you use a text datatype criteria for example for a numerical or date/time table field you will receive the error

Double check that all criteria datatype matches the datatype of the underlying table column datatype

You use a currency symbol in the criteria of a currency datatype. For example, you type £10.50 or $10.51 as the criteria

Don't use the currency symbol for currency datatypes

You're trying to use a JOIN in a query on datatypes that don't match

Only specify JOINS on the same datatype