If you'll notice my first query groups on car, so I get the max date for each car. You'd want to group on document.
If you'll notice my first query groups on car, so I get the max date for each car. You'd want to group on document.
Don't pull your hair out.
The probable answer has been given at least twice but it doesn't appear you are reading the posts.
GROUP BY Document and MAX RevDate
I tried that car mileage one and it gave me the highest revision in each TYPE of document. Well that's great! BUT it's not showing me the highest revs in every project, it's filtering only by document name, here is what I have, maybe someone can help me tweak it
SELECT Max(DataQuery.Revision_Number) AS Max_Rev, DataQuery.Document_Description
FROM DataQuery
GROUP BY DataQuery.Document_Description;
Then it sounds like you should be grouping on project instead of document description?