I don't think you can do it in one query. The following is one method that may work with your current structure. For best performance, create 5 queries and Save them (qProgTop5_n) and then use a UNION query to get them all in one query. SELECT TOP 5 Progress1 as ProgDate , Reference FROM Log ORDER BY Progress1 DESC SELECT TOP 5 Progress2 as ProgDate , Reference FROM Log ORDER