• Unfortunately there is no such function in Access. Two possible approaches you might consider:

    1) open a recordset on your data and perform a rank calculation on each record using a VBA procedure and then select only records ranked on or two.

    2) try using a self-join (Access allows that) with a combination of Max functions on the appropriate parameter.

    Both of those may require that you have a unique key to identify a specific record.

    Also, what do you want to do if you have several records of a given type that are all equal?

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!