M
MrMike
Hi. I have the query as shown below. When executed it produces the error
"Syntax error (missing operator) in query expression tblSQFTByStation.OrderID
= tblOrder.OrderID
INNER JOIN tblOrderDetail on tblSQFTByStation.OrderID =
tblOrderDetail.OrderID" I can't figure out what is wrong. Could someone
please assist? Thanks!
SELECT tblSQFTByStation.OrderID, IIF(ECD_CutOff Is Null, "","CutOff") as
Station, CutOff as Requirements,(SELECT SUM(tblOrderDetail.Width) FROM
tblOrderDetail WHERE tblOrderDetail.FlitchNum = tblSQFTByStation.OrderID)
FROM tblSQFTByStation
INNER JOIN tblOrder on tblSQFTByStation.OrderID = tblOrder.OrderID
INNER JOIN tblOrderDetail on tblSQFTByStation.OrderID = tblOrderDetail.OrderID
WHERE ((ECD_CutOff Is Not Null) AND (tblOrder.StatusID = 3 OR
tblOrder.StatusID = 4 OR tblOrder.StatusID = 5 OR tblOrder.StatusID = 6 OR
tblOrder.StatusID = 7 OR tblOrder.StatusID = 12 OR tblOrder.StatusID = 13));
"Syntax error (missing operator) in query expression tblSQFTByStation.OrderID
= tblOrder.OrderID
INNER JOIN tblOrderDetail on tblSQFTByStation.OrderID =
tblOrderDetail.OrderID" I can't figure out what is wrong. Could someone
please assist? Thanks!
SELECT tblSQFTByStation.OrderID, IIF(ECD_CutOff Is Null, "","CutOff") as
Station, CutOff as Requirements,(SELECT SUM(tblOrderDetail.Width) FROM
tblOrderDetail WHERE tblOrderDetail.FlitchNum = tblSQFTByStation.OrderID)
FROM tblSQFTByStation
INNER JOIN tblOrder on tblSQFTByStation.OrderID = tblOrder.OrderID
INNER JOIN tblOrderDetail on tblSQFTByStation.OrderID = tblOrderDetail.OrderID
WHERE ((ECD_CutOff Is Not Null) AND (tblOrder.StatusID = 3 OR
tblOrder.StatusID = 4 OR tblOrder.StatusID = 5 OR tblOrder.StatusID = 6 OR
tblOrder.StatusID = 7 OR tblOrder.StatusID = 12 OR tblOrder.StatusID = 13));