Fetching top 5 distinct records 1

[evergreean43]

I currently have a query where I use distinct to fetch distinct lastnames from my Access 2000 database:

select distinct lastname, firstname from user;

Now I need to just fetch the top 5 but it gives me error when I do it:

select top 5, distinct lastname, firstname from user;

Please advise.

 

[Remou]

From the Query Design screen, I get:
[tt]SELECT DISTINCT TOP 5 user.lastname, user.firstname
FROM [user];[/tt]

 

[evergreean43]

thanks