Home -> Usenet -> comp.databases.oracle -> Forms 4.5 Running Totals

     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.


     Thanks in advance...



     Graeme King
     Information Systems Engineer
     Information Services
     Strathkelvin District Council

     email : graeme_king_at_tjhouse.ccmail.compuserve.com