Help on mismatch errors

[Guest]

Ive made a report from two tables that are linked by an autonumber which is
also the primary key in one table to a text box in another. When i try to
preview the report it says there is a mismatch error and pressing help says
that i have a mismatch in the join expression. Now im guessing its becausi
have an autonumber linking with a textbox but dont know how to solve it
without chaging the tables. Is there a way?

 

[Guest]

If all you store in this text box is numbers, I would suggest you change the
type of the field to number.

If for any reason it is to late, you can change the type of the field in the
join while you are in SQL view.

SELECT Table1Name.*
FROM Table2Name INNER JOIN Table1Name ON Val(Table2Name.TextFieldName) =
Table1Name.AutoNumberFieldName

Or, create a query based on Table2, and convert the Text Box to number, and
then link Table1 to the query using the AutoNumber to the converted field