i solved my compute counts problems - sorry to bother you - here is the answer

set pagesize 0
set lines 60
set feedback off
clear breaks;
clear computes;

ttitle 'Sender Transaction|Report'
btitle 'Confidential'
break on sender3 skip 2
compute sum label 'Transaction Count' of transaction_count on sender3

column sender3 HEADING 'Sender' FORMAT A20 column inq_type HEADING 'Transaction Type' FORMAT A20 column transaction_count HEADING 'Transaction Count' FORMAT 99999999 select sender3,inq_type,count(inq_type) transaction_count from gail_trans_log
group by sender3,inq_type

Thanks anyway,

Gail Buffington Received on Tue Aug 27 2002 - 09:34:20 CDT