I'm having some trouble with a query. I set up a query that looks at a status update table and let me know which entries have a update date older than 30 days. I need it to generate a report on vehicles that have not been inspected for over 30 days. The problem I am running into is that it does only show me vehicles with dates older than 30 days but, even if a new update has been enter for that Vehicle ID, it still shows the old status based on the previous date. I can't delete the old record as I need to keep a history of each update. Can anyone help with this?