I keep on getting a Data Type Mismatch in Criteria Expression error whenever I
try and run this query. It is causing the error in the PARTNO field. All
the fields are text and 15 in length. Here is the code for the query:

SELECT [TIW MRPTrans - SOMATER Select].[SONO] & "." & [TIW MRPTrans -
SOMATER Select].[OPNO] & "_" & [TIW MRPTrans - SOMATER Select].[PNO] AS
PKEY, [TIW MRPTrans - SOMATER Select].pno
FROM (([TIW Open Orders] LEFT JOIN [BOM ParentDepts] AS [BOM ParentDepts_1]
ON [TIW Open Orders].PARTNO = [BOM ParentDepts_1].PARENT) INNER JOIN [TIW
MRPTrans - SOMATER Select] ON [TIW Open Orders].SONO = [TIW MRPTrans -
SOMATER Select].sono) LEFT JOIN [BOM ParentDepts] ON [TIW MRPTrans - SOMATER
Select].pno = [BOM ParentDepts].PARENT
WHERE (((CDbl(IIf([QTY_REM] Is Null,"0.00",[QTY_REM])))<>0));

Please help me if you can.