>>>>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, thanks, I'm getting some ideas now. About your quote. It seems World Peace is NOT the default setting for this world, unfortunately.