>I want to know if a program or a report is the way to go on this.
>I have a transaction file: stock#, itemname, price, qty. If I want to see a listing(or report) of each different stock# with the number sold and the dollar amt sold, would a prg have to be the way to accomplish this?


A SELECT statement or view could handle this for you.