Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    64

    Unanswered: select last 3 records

    How can I restrict a continuous form to select only the last three records

    any help would be appreciated

    Peter

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Oder by Dessending then Slect top 3

  3. #3
    Join Date
    Dec 2004
    Location
    Netherlands
    Posts
    11
    set the record source of the form to this kind of query:

    SELECT top 3 Columname
    FROM tablename
    order by Columname Asc

    Asc or Desc
    ascending or descending - the top or the bottom 3 records

  4. #4
    Join Date
    Nov 2004
    Posts
    64
    Thanks Guys that code is what i needed

    SELECT top 3 Columname
    FROM tablename
    order by Columname Asc

    You have made my day

    thanks

    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •