>VFP 9. Have a row of house sales with four columns. The fields are listed below. Sales year and month are character fields. I want all four columns returned for the most recent sale for each unique houseid.
>
>Table Fields
>houseid, sales month, sales year, sale amount,
>
>Thanks
>
>Brenda

How about???

SELECT houseid,MAX(sales_year + sales_month) AS mo;
 FROM myTable;
 GROUP BY 1;
 INTO CURSOR curTemp

SELECT myTable.*;
 FROM myTable,curTemp;
 WHERE myTable.houseid = curTemp.houseid;
   AND myTable.sales_year + myTable.sales_month = curTemp.mo

Bear in mind that if you have multiple records for a year/month combination, you will get multiple rows returned in the final result.