Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Last 15 Records (A2K)

    I really have to learn how to search the Forum correctly because I know I have run across this seemingly simple thing in the past.
    How do I select the last 15 records in a query and display them in descending order?
    Cheers,
    Andy

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last 15 Records (A2K)

    Create a query ascending and enter 15 in the Top Values property.
    Create a new query based on the previous and sort it descending.
    Francois

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Last 15 Records (A2K)

    Sort your query in descending order on the field you want to sort on.
    Click in an empty part of the upper half of the query design window.
    In the Properties window, enter 15 in the Top Values property (it's not in the dropdown list, but you can type it in)

  4. #4
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last 15 Records (A2K)

    Francois & Hans,

    You two gentlemen always make it like Christmas morning under the Access programmer's Christmas tree! Thanks as always,
    Cheers,
    Andy

Posting Permissions

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