MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Delete query


Posted by Ben Thompson on May 04, 2001 10:16 AM

I have a set of records that contain a date range. I need to select the records with the MAXIMUM date in the recordset. If the record does not contain the maximum date, then delete the record. This process needs to be in an automated fashion that will start when the file is opened.


Posted by Phillip M. Beerman on May 04, 2001 12:26 PM

First insert a new line above your first data row. Above the column containing the date type: MAX([RANGE]MM/DD/YYYY).
Highlight all data and hit delete. Then save. When you open the file only the most recent date will remain.

Phillip

P.S. There may be a good way to do this in access as well.