I am using HSGLDB database and what works in another database does not work in this new one.
This works SELECT “Cost” * .2 AS “VAT1” FROM “tblRecInfo”
But this doesn’t:
SELECT “NetCost” * .05 AS “VAT” FROM “tblEonEnergyPlan”
In the SQL window from Tools, the output is just commas, and no figures.
The NetCost is to be calculated by the query, then the VAT figure added to it. I have found that if I use any other field ie Payment or UsageCharge, the VAT figure is calculated and shown. Also , if I enter a figure in the NetCost field, the VAT is calculated and shown. I must be missing something blindly obvious!
Thanks for your patience.