SELECT TOP fast way...

[sal21]

SELECT TOP 6 VE.ANNO FROM VE GROUP BY ANNO

is this the fast way to extract top 6 ANNO in Access table with approx 165.xxx records?

Note:
ANNO is indexed

[HansV]

Yes.

[HansV]

By the way, if you want to select the 6 most recent years, you must sort in descending order:

SELECT TOP 6 ANNO FROM VE GROUP BY ANNO ORDER BY ANNO DESC

[sal21]

By the way, if you want to select the 6 most recent years, you must sort in descending order:

SELECT TOP 6 ANNO FROM VE GROUP BY ANNO ORDER BY ANNO DESC

TKS!