I have constructed a passthrough query in Ms Access shown below and in its current form it is working as expected:
Now I want to include the final column as below, then it fails to work what should I do with this column:
What is the correct syntax for the new column above?
Code:
SELECT tblPOSStocksSold.ItemSoldID, tblPosLineDetails.ItemesID, tblProducts.ProductName, tblPosLineDetails.QtySold, tblPosLineDetails.SellingPrice, tblPosLineDetails.IsTaxInclusive, tblPosLineDetails.RRP, tblPosLineDetails.Tax, (([QtySold]*[SellingPrice])-(([QtySold]*0))) AS TotalAmount, tblPosLineDetails.TaxClassA, tblPosLineDetails.ProductID, tblPosLineDetails.TourismClass, tblProducts.BarCode, tblPosLineDetails.InsuranceClass, tblPosLineDetails.ExciseClass, tblPosLineDetails.TurnoverTax, tblPosLineDetails.Bettings, tblPosLineDetails.Duty
FROM tblPOSStocksSold INNER JOIN (tblProducts INNER JOIN tblPosLineDetails ON tblProducts.ProductID = tblPosLineDetails.ProductID) ON tblPOSStocksSold.ItemSoldID = tblPosLineDetails.ItemSoldID;
Now I want to include the final column as below, then it fails to work what should I do with this column:
Code:
IIf([IsTaxInclusive]<0,"True","False") AS CGControl
What is the correct syntax for the new column above?