I realise this may be a silly question, but without me trawling the net for hours, I wanted to ask here.
I am using HSQLDB database, and have a query which has 2 calculated fields, as in 2 x 4 for example, and it works just fine. After I designed the form etc and then added the price of an item and the delivery cost, the vat and total price were not updated or shown on the form.
The fields are VAT and TotalCost, which are updated in the query but not the form. The following SQL works in the query
SELECT “Cost” * .2 AS “VAT1”, “Cost” + “DelCost” + ( “Cost” * .2 ) AS “TOTALCOST1” FROM “tblRecInfo”