I would like a query to return the last 12 records of a table where the table is ordered in ascending order.
I know that "Top 12" works to return the first 12 records but I want the last 12 in the same order.
Thank You!!
I would like a query to return the last 12 records of a table where the table is ordered in ascending order.
I know that "Top 12" works to return the first 12 records but I want the last 12 in the same order.
Thank You!!
Last edited by a-dre; Dec 28, 2004 at 02:07 PM. Reason: Mispelled word
Why not sort the tables in descending order and get the top 12? You can always loop through the records in any direction to get them in the order you want.
"The best software is the one that fits your needs." - A_A
Virus free since: date unknown
Anti-virus free since: August 2008