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