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?
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

This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
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
http://www.wopr.com/S/Belgium.gif
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)
Francois & Hans,
You two gentlemen always make it like Christmas morning under the Access programmer's Christmas tree! Thanks as always,
Cheers,
Andy