I need help building a query. I am pulling data from two tables, one called ‘Subject’ the other called ‘Work’. The ‘Work’ table records activity performed on a subject from the ‘Subject’ table. Each entry is time stamped with the date (field called ‘EntryDate’).
The relationship between the two tables is on the subject.
In my query I would like to pull the most recent date an entry was made on a given subject. I am able to create a query that pulls the data for each entry, but I would like to know how to filter it down to only the most recent date.
Any help would be appreciated.
(I am new to the forum and have searched for this question/solution but did not find what I was looking for, so I apologize if this has been answered before.)