How can I add the delivery charge before VAT onto this query.
Total Sale: Sum(CLng(nz([Quantity]*[UnitPrice]*(1-[Discount]))*100)/100)
Thank you in advance for your help!

Total Sale: (Sum(CLng(nz([Quantity]*[UnitPrice]*(1-[Discount]))*100)/100)+[Delivery])*1.175

Assuming one charge and 17.5% VAT

Your better off storing the vat rate for each transaction, since it can be changed at will.