Returning Last Instance of a Duplicate

[Dopple444 via AccessMonster.com]

I have a table with Multiple records for the same serial number. I need to
return only the latest record and the next previous record based on the date
of the occurence. Can any one help me wit this scenario?

 

[Michel Walsh]

You can use one of the four methods presented at
http://www.mvps.org/access/queries/qry0020.htm



Hoping it may help,
Vanderghast, Access MVP