yahshuah
asked on
subtract amount of two fields
subtract amount of two fields
[tblPurchaseOrder.Amount]* .12 as VAT, [tblPurchaseorder.Amount] - [Vat] as exVat, tblPurchaseorder.Amount
but exVat is = tlbpurchase.Amount it doesnt subtract tblpurchaseorder.Amount*0. 12
whole sql querry
[tblPurchaseOrder.Amount]* .12 as VAT, [tblPurchaseorder.Amount] - [Vat] as exVat, tblPurchaseorder.Amount
SELECT tblPurchaseOrder.ProductID , tblPurchaseOrder.Descripti on, tblPurchaseOrder.Quantity, tblPurchaseOrder.Unit, tblPurchaseOrder.UnitPrice , tblPurchaseOrder.PreparedB y, tblPurchaseOrder.ApprovedB y, tblPurchaseOrder.PurchaseO rderNo, tblPurchaseOrder.Status, [tblPurchaseOrder.Amount]* .12 as VAT, [tblPurchaseorder.Amount] - [Vat] as exVat, tblPurchaseorder.Amount
FROM tblPurchaseOrder INNER JOIN tblSupplier ON tblPurchaseOrder.SupplierI D = tblSupplier.SupplierID
WHERE (((tblPurchaseOrder.Status )="Approve d")) and (((tblPurchaseOrder.quanti ty)<>0)) ;
[tblPurchaseOrder.Amount]*
but exVat is = tlbpurchase.Amount it doesnt subtract tblpurchaseorder.Amount*0.
whole sql querry
[tblPurchaseOrder.Amount]*
SELECT tblPurchaseOrder.ProductID
FROM tblPurchaseOrder INNER JOIN tblSupplier ON tblPurchaseOrder.SupplierI
WHERE (((tblPurchaseOrder.Status
[tblPurchaseOrder.Amount]* .12 as VAT, [tblPurchaseorder.Amount] -([tblPurchaseOrder.Amount ]*.12) as exVat, tblPurchaseorder.Amount
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.