Something like this (try this out in the sample Northwind database)?
SELECT TOP 1 Products.ProductID, Products.ProductName,
Min(Products.UnitPrice) AS [Unit Price]
FROM Products
GROUP BY Products.ProductID, Products.ProductName
HAVING (Products.ProductID)
In (SELECT
TOP 20 Products.ProductID
FROM Products ORDER BY Products.UnitPrice DESC)
ORDER BY Min(Products.UnitPrice);
Tom Wickerath
Microsoft Access MVP
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
Tim said:
I'm looking for a query that would return the 3rd highest, or 20th highest
value from list of values. Something like Max(field, -3), but obviously
that wouldn't work.
Any suggestions are appreciated!