Trying to learn a new trick here. I have a table littered with duplicate records. I'm only concerned with two data fields: Receipt Number and Receipt Date. I want to keep only the record of the latest Receipt Date.
How do I run a delete query and single out only the older receipt dates for deletion?