Query Date Criteria

[svanicek]

Is there a way to put criteria into a date field to only bring in the most recenct two dates? For example I want to see the most recent two dates an employee sumitted a claim, by employee name. The dates are contained in the same field there are seperate records for the same employee on different dates. I want the query to return two records for each employee one with the most recent date, one with the second most recent date.

[pbaldy]

Sounds like this:

ACC: How to Create a Top N Values per Group Query