I need to be able to pull one record where multiple records exist in a table in a table. Basically where more than one record exists I want to take the record with the furthest date in the future based on a date field in the table.
Any help is appreciated
Any help is appreciated