1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| -- QryOrdersMaster
SELECT tblOrders.OrId,
tblOrders_Sub.OrTpet,
tblOrders_Sub.OrVatRate,
tblOrders.OrVatRate1,
tblOrders.OrVatRate2,
tblOrders.OrDiscountRate,
[OrTpet]*[OrDiscountRate] AS OrDiscount,
[OrTpet]-[OrDiscount] AS OrCna,
tblOrders.OrCashDiscountRate,
[OrCna]*[OrCashDiscountRate] AS OrCashDiscount,
[OrCna]-[OrCashDiscount] AS OrNaet,
tblOrders.OrShipping,
tblOrders.OrPacking,
IIf([OrVatRate]=[OrVatRate1],[OrNaet],0) AS OrNtet1,
IIf([OrVatRate]=[OrVatRate2],[OrNaet]+[OrShipping]+[OrPacking],0) AS OrNtet2,
[OrNtet1]*[OrVatRate] AS OrVat1,
[OrNtet2]*[OrVatRate] AS OrVat2,
[OrVat1]+[OrVat2] AS OrVat,
[OrNtet1]+[OrNtet2]+[OrVat] AS OrNtit
FROM tblOrders
INNER JOIN tblOrders_Sub
ON tblOrders.OrId = tblOrders_Sub.OrId; |
Partager