Re: Forms 4.5 Running Totals

One solution to be used with caution is: execute_query (all_records). This way, you can just keep your post-query and everything will be ok. The disadvantage, though, is it will retrieve ALL records that meet the query criteria --- not advisable for a query that returns tons of rows.

Another solution is if you know exactly what the condition is, use "select sum (column_name) from tablename where ????" or use the solution suggested by Steve about record groups and "system.last_query".

--
Kim Ng
Paradigm Computer Consulting, Inc.
(standard disclaimer applies. If you don't know what it is, you shouldn't be
reading this)