Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version


While waiting for a reply I put a sample together. There are two forms: QueryMultiply and CalcFields.

QueryMultiply uses a simply query as it data source:

SELECT "Name", "Amount1", "Percent1", "Amount1" * "Percent1" AS "CalcTotal", "ID" FROM "Table1"

And uses that to display the result. Of course the result is only available after the record is entered.

CalcFields uses a macro to get the result of the amounts entered in the Numeric fields.

Sample: SQLselect1.odb

If this answers your question please click on the ✔ (upper left area of answer).