Re: Forms 4.5 Running Totals
Date: 1995/07/08
Message-ID: <3tll5r$ino_at_zorn.mnet.medstroms.se>#1/1
Graeme_King_at_tjhouse.ccmail.compuserve.com wrote:
>
> Can anybody supply a solution to this problem?
>
> I have a multi-record block (displaying 5 records) based on a table,
> called for example EMP. The block has an item called SALARY in it.
>
> I want a text item (on a different block) which is a total of the
> SALARY column for all records queried (which may be one, many or all
> of the records in the table EMP).
>
> I tried a POST-QUERY trigger to calculate the total salary but it only
> fired 5 times i.e for each displayed record although there were more
> than 5 that meet the query criteria. When I scrolled down one record
> it fired again and updated the total salary. No good.
>
A quick fix: keep your post-query like that and program key-exeqry of the queried block like this:
execute_query;
last_record;
Received on Sat Jul 08 1995 - 00:00:00 CEST