Querying the most recent record

[halabis]

I am attempting to design a query that will pull the most recent entry into to database for each employee that meets a specific criteria. I then need to Every tutorial I can find on how to do this is for Access 2007 and has you enter values into the "Total" line on design view. As far as I can tell there is no such equivalent of this in Access 2013.



So if I have the Following

Employee / Date / Filter
Bob / 10-1/15 / Yes
Bob / 10-5-15 / No
Bob / 9-1-15 / Yes
Sam / 6-1-15 / Yes
Sam / 6-2-15 / Yes


I would like the query to return

Bob / 10-1-15 / Yes
Sam / 6-2-15 / Yes


As those are the most recent dates for each employee for which the filter field is a "Yes"

Thanks!

[June7]

Review http://allenbrowne.com/subquery-01.html#TopN

[NTC]

This is done in 2 steps. First make a query 'TheYesGroup' ...that is a select query with the criteria of Yes.

then make an Aggregate query using TheYesGroup as its record source - and set the date field to Max...let the other fields remain at the default Group.

[CJ_London]

It can be done in one query

SELECT *
FROM myTable
WHERE myDate= (SELECT Max(myDate) FROM myTable AS T WHERE Employee=myTable.Employee AND myFilter = True)

note that date and filter are reserved words so should be changed in your solution

filter may be text rather than Boolean so change to suit

also see the answer here

https://www.accessforums.net/queries...tml#post300708

almost the same question