>>>>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.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."