Can anyone tell me why am I getting error in the below query?
Need some advice as I am new to Access
SELECT PTblPOs.PONo, PTblOrderHeaders.OHSBNo, PTblOrderLines.OLName, PTblOrderHeaders.OHInvApprover, PTblOrderHeaders.OHInvCCRec, PTblOrderHeaders.OHEntCodeRef, PTblOrderHeaders.OHVenCodeRef, PTblInvoices.InvNumber, PTblInvoices.InvDate, PTblInvoices.InvQuant, PTblInvoices.InvAmt, PTblInvoices.InvText, PTblInvoices.InvComment, PTblInvoices.InvIPNoRef, PTblInvoices.InvGRReqDate, PTblPOs.POSelfDelivery, PTblPOs.POLine, PTblGRs.GRQuant, PTblGRs.GRAmt, PTblGRs.GRNo_iShop, PTblGRs.GRNo_SAP
FROM (PTblOrderHeaders
INNER JOIN
PTblOrderLines ON PTblOrderHeaders.OHSBNo = PTblOrderLines.OLSBNoRef)
INNER JOIN
(PTblPOs
INNER JOIN
((PTblInvoices LEFT JOIN PTblInv2GR ON PTblInvoices.[InvID] = PTblInv2GR.[I2G_InvIDRef])
(PTblGRs ON PTblGRs.GRID = PTblInv2GR.I2G_GRIDRef )) ON PTblPOs.POLineID &PTblPOs.POLineID = PTblInvoices.[InvPOLineIDRef]&PTblGRs.[GRPOLineIDRef)
ON PTblOrderLines.OLID = PTblPOs.PO_OLIDRef
WHERE (((PTblPOs.POSelfDelivery)=False) AND ((PTblInv2GR.I2G_InvIDRef) Is Null);
Need some advice as I am new to Access
SELECT PTblPOs.PONo, PTblOrderHeaders.OHSBNo, PTblOrderLines.OLName, PTblOrderHeaders.OHInvApprover, PTblOrderHeaders.OHInvCCRec, PTblOrderHeaders.OHEntCodeRef, PTblOrderHeaders.OHVenCodeRef, PTblInvoices.InvNumber, PTblInvoices.InvDate, PTblInvoices.InvQuant, PTblInvoices.InvAmt, PTblInvoices.InvText, PTblInvoices.InvComment, PTblInvoices.InvIPNoRef, PTblInvoices.InvGRReqDate, PTblPOs.POSelfDelivery, PTblPOs.POLine, PTblGRs.GRQuant, PTblGRs.GRAmt, PTblGRs.GRNo_iShop, PTblGRs.GRNo_SAP
FROM (PTblOrderHeaders
INNER JOIN
PTblOrderLines ON PTblOrderHeaders.OHSBNo = PTblOrderLines.OLSBNoRef)
INNER JOIN
(PTblPOs
INNER JOIN
((PTblInvoices LEFT JOIN PTblInv2GR ON PTblInvoices.[InvID] = PTblInv2GR.[I2G_InvIDRef])
(PTblGRs ON PTblGRs.GRID = PTblInv2GR.I2G_GRIDRef )) ON PTblPOs.POLineID &PTblPOs.POLineID = PTblInvoices.[InvPOLineIDRef]&PTblGRs.[GRPOLineIDRef)
ON PTblOrderLines.OLID = PTblPOs.PO_OLIDRef
WHERE (((PTblPOs.POSelfDelivery)=False) AND ((PTblInv2GR.I2G_InvIDRef) Is Null);
Last edited: