first three results

[slimjen]

All using access 2010. I have a table that has notes and foreign key from customer table(custid). When a note is entered; it is followed by a date. Some customers have 3 or more notes entries. I want to only keep the latest 3 entries and delete the records beyond 3. How can I write a query to get these results. I tried grouping but this only gives me the last one or max. If a customer has four note entries; I want to keep the last three. If a customer has only 1 or 2 note entries; I want all of the entries in the results. Can this be done and if so; how please. Thanks

[June7]

One way is with TOP N parameter. Review http://allenbrowne.com/subquery-01.html#TopN

[slimjen]

Perfect. I knew it was something simple. Thanks a bunch!