Find 2nd or 3rd highest record with a query

[K Roger]

There are fairly simple queries to find the maximum or minimum value for a field in a grouped by query that may have 2-3 or more groupings, but is it possible to find, say the 2nd and/or 3rd highest values and their associated fields in an ACCESS (2003) query? or must one resort to VBA programming. In either case, how is this done - if it can be done?



Thanks,

[June7]

Finding top 3 is fairly easy - see http://allenbrowne.com/subquery-01.html

Picking out the 2nd or 3rd is trickier. Google: sql second highest query

Here is one http://blog.sqlauthority.com/2008/04...maximum-value/