I have a query as below. Both SOLSONO and SOLLINE in each table are data type number, but I get the data mismatch error.
This is the SQL from the query.
SELECT tblPrintedJobsheets.SOLSONO, tblPrintedJobsheets.SOLLINE, tblPrintedJobsheets.SOHCREF, tblPrintedJobsheets.SOLCUSC, tblPrintedJobsheets.SOLBAL, tblPrintedJobsheets.SOLDATO, tblPrintedJobsheets.PTM1CD, tblPrintedJobsheets.JOBPRINTEDFROM tblPrintedJobsheets, tblSalesOrderRptNo
WHERE (((tblPrintedJobsheets.SOLSONO)=[tblSalesOrderRptNo].[SOLSONO]) AND ((tblPrintedJobsheets.SOLLINE)=[tblSalesOrderRptNo].[SOLLINE]));
Cheers
Bill