I remember doing this in Query on the system/38; I recall that the trick was
to created a calculated field with a formula of +1.
Query/38 also did tables and there were many occasions I cursed WRKQRY on
the 400 for not having this feature.
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Tuesday, 22 September 2009 5:03 p.m.
Subject: Re: WRKQRY running total
Booth Martin wrote:
There is a debit field and a credit field in the record layout.
The requirement is to print a third column which is a running
total. In RPG it would be
runtotal = runtotal + debit - credit
I want to do this with query but can't figure it out.
The Query/400 feature offers only its /summary functions/
accumulators. There are no other accumulators [e.g. running totals]
supported in WRKQRY; i.e. the value of prior row(s) is not tracked,
except for effecting the summaries for the /report breaks/. The
Query/38 feature [DSNQRYAPP] however, does offer running totals;
effectively the same question & response here: