The below query is giving syntax error.

SELECT Tbl_Inventory.CrDate, Tbl_Inventory.QtyOpStk, Tbl_Inventory.QtyClStk,
Tbl_Inventory.ExcShortage FROM (Tbl_Inventory
LEFT OUTER JOIN
Tbl_PurchaseMain ON (Tbl_Inventory.CrDate = Tbl_PurchaseMain.idate))
LEFT OUTER JOIN
Tbl_SalesMain ON (Tbl_Inventory.CrDate = Tbl_SalesMain.idate)
INNER JOIN
Tbl_ProductGroupMaster on (Tbl_Inventory.proid = Tbl_ProductGroupMaster.PROID)

vinodh

Try

SELECT Tbl_Inventory.CrDate, Tbl_Inventory.QtyOpStk, Tbl_Inventory.QtyClStk,
Tbl_Inventory.ExcShortage
FROM ((
Tbl_Inventory
LEFT OUTER JOIN
Tbl_PurchaseMain ON (Tbl_Inventory.CrDate = Tbl_PurchaseMain.idate))
LEFT OUTER JOIN
Tbl_SalesMain ON (Tbl_Inventory.CrDate = Tbl_SalesMain.idate))
INNER JOIN
Tbl_ProductGroupMaster on (Tbl_Inventory.proid = Tbl_ProductGroupMaster.PROID)

Brian