Rob Waite

I only want to display the top 4 only (i know the post subject says 6, but i meant 4)

Yeah, thats right - with an ORDER BY on the end

Hello,I have written a statement to get the TOP 4 from a Particular table, based on a Number Field (ORDER BY DESC)My problem is that if this number field that i'm using to order by has, for example the same value 7 times then i get a return of 7 rows.eg.Letter NumberA 10B 10C 10D 9E 9F 8I want the an SQL statement to get the TOP 4 from this, but as you can see D & E have the same values, so i returns 5 rows.I am using an ACCESS database, any help would be appreciated.Rob