I have a couple of Access databases which have caculation queries, and I am finding that it is not that simple in base.
For example, I want to calculate the vat amount on an item price, so I tried this: VAT AS “‘Cost’ *0.2” , but it doesn’t work.
Cost is say £29.95, so what is the vat payment of 20 percent.
I have looked at the HSQL manual for this and it only describes more complex queries with multiple fields, and I have tried similar SQL code but for my needs to no joy.
@librebel, I did try that earlier and it gave me a syntax error.
@EasyTrieve, thank you that has done the job for me. Yes, the manual is good if you know where to look.