I have a table with partno, status, and date fields. There are duplicate partno's but each have a different date. The status is either 1(accepted) or 2(rejected). It is my goal to find the partno's with the latest date that are at a status of 1. Management needs to know the percentage of partno's not cleared through First Article Inspection(status).