Data mismatch means you joined a number with a string. Cant do that.
The two data types must match.
1 table field is set to number
the other field is a string.

You CAN cheat by making a query that converts the number to string...CSTR(fld)
THEN Join.