Jump to content

Rob Waite

Members
  • Posts

    3
  • Joined

  • Last visited

Rob Waite's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. I only want to display the top 4 only (i know the post subject says 6, but i meant 4)
  2. Yeah, thats right - with an ORDER BY on the end
  3. 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
×
×
  • Create New...