>Hi Expert
>
>I have a Table of about 100000 records of about 3000 Codes. I want to select Code,Last Pur.Rate with Date of each code.
>
I think you're saying that you want to find out the last purchase date for each item in the table. If that's it, try:
SELECT Code, MAX(PurchaseDate) ;
FROM YourTable ;
GROUP BY Code ;
INTO CURSOR csrLastPurch
You'll need to substitute the actual field names and the table name, of course.
If that wasn't what you wanted, can you explain better, or show some sample records and sample output.
Tamar