2. ASPRunnerPro General questions
  3. access formulae calculations
This topic is locked

access formulae calculations

 		10/10/2004 3:01:50 PM
ASPRunnerPro General questions
author

a simple database which calculates the total by multiplying the "price" and the "quantity" fields. when deployed in asprunner "total" field becomes static and does not automatically update itself. is there a workaround?

thanks
Sergey Kornilov admin 10/11/2004

Seth,
you can create a query in MS Access that calculates totals on the fly and use this query as a datasource in ASPRunner.

select price, quantity, *pricequantity as total** from TableName