I have this table that records sales events for properties, with multiple sales records for some parcels. Each parcel has unique field: MapTaxlot. I want to create a select query or make table query that shows only the most recent sale event for each parcel. Instrument_Date is the date field for the sales records.
See attached example of the data table below.
What is the simplest method to accomplish this?
Thanks,
![TableSnip.JPG TableSnip.JPG](https://accessprogrammers.b-cdn.net/forums/data/attachments/44/44686-8dda138aa01e432172e68d39f4e21c8c.jpg)
See attached example of the data table below.
What is the simplest method to accomplish this?
Thanks,
![TableSnip.JPG TableSnip.JPG](https://accessprogrammers.b-cdn.net/forums/data/attachments/44/44686-8dda138aa01e432172e68d39f4e21c8c.jpg)