Short answer - you need to turn this into a totals query and group by everything but the date. Get MAX(Date). Or use a subquery to return only the latest posting.