Search results

Thanks for your replay i have solved the issue by making 4 query each one must have at most 16 union what i do is SELECT * FROM qryUnion1 union all SELECT * FROM qryUnion2 union all SELECT * FROM qryUnion3 union all SELECT * FROM qryUnion4;

Hi , Please i have the same error message this is my code SELECT tblReceiptVoucherDetails.[COMPANY_NAME] & " " & tblReceiptVoucherDetails.[Date] & " " & tblReceiptVoucherDetails.[Quantity] AS Expr1, tblTestPoints.COMPANY_NAME, tblTestPoints.MODEL ,tblModelCost.Description ...