>>>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.
>
>Got any select statements on you?

How about:

select * from Transaction;
  where TransactionDate between ldFromDate to ldToDate;
  order by TransactionDate;
  into cursor Temp
scan
  ? StockNumber, ItemName, Price, Quantity
  * "?" is useful for creating a text-file.
endscan

What else do you need?

Hilmar.