I am using MS Access database and the following query generate support error in crystal report.
SELECT
Item.`Item_Code`, Item.`Item_Name`, Item.`OP_QTY`, Item.`OP_Rate`,
Stock.`voucher_no`, Stock.`voucher_date`, Stock.`quantity`, Stock.`rate`, Stock.`DC`,
Users.`User_Name`,
Company.`Comp_Name`, Company.`Address`
FROM
((`Stock` Stock RIGHT OUTER JOIN `Item` Item ON Stock.`item_id` = Item.`Item_Code`) INNER JOIN `Company` Company ON Stock.`comp_id` = Company.`Reg_No`) INNER JOIN `Users` Users ON Stock.`user_id` = Users.`User_Id`
ORDER BY
Item.`Item_Code` ASC