Formula's in Queries

[quigongrim]

I've made a query for my sales database. It finds all the items under a particular manufacturer, and how many items they have sold.

I need to create a formula (inside the query if possible) to do the following:



FIELD = ((TRADE PRICE * QTY)-VAT)

Does anyone know how I do this?

[weekend00]

select ((TRADE PRICE * QTY)-VAT) as FIELD , otherfieldlist from tablename ...