Calculated Fields in a Query
Posted on 2003-11-26
I have a series of queries where I populate the SQL at runtime so I do not have lots of Query components on my form.
I need to add calculated fields at runtime, but I cannot work out how to do it.
I cannot just add to my SQL something like "Qty*UnitPrice AS Amount" - I need to be able to call functions from OnCalcFields.