Find 2 most recent dates

[ssanfu]

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



Also try googling:

query top n by group

[alansidman]

Look at this video. I think that this may be what you are looking for

http://www.datapigtechnologies.com/f...spergroup.html

[cmiley]

Thanks InsuranceGuy. This worked perfectly. It really helped being able to look at it in this format.