Re: Show Last 20 rows

Open a new query in design view (the query grid)
Add your table
Add ID and Measure to the fields
Sort by ID in descending order
Double click on a blank area of the top section
You should see Query Properties ***
Change Top Values to 5 (if you want the top 5)


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Kevin wrote:
Hi,

Thanks for advise....!
but still can't understand...? below is the table i using to colect measurement data. i just want get the latest 5 measurement only meaing from 5 to 10 row.

Please advise

id | Measure |
-----------------
1 0.45
2 0.50
3 0.41
4 0.42
5 0.40
6 0.30
7 0.46
8 0.42
9 0.43
10 0.40


"John Spencer" wrote:

First, define the last twenty rows? Data is not stored in any specific order. If you want the last 20 rows there must be something in a field (or fields) that specifies that this row is one of the last 20?

Another way to think about that is there must be a field or fields that you can sort by that will put the records in an order so that the last 20 rows can be picked.

Take a look at using TOP 20 in a query that orders the rows in the manner you want.

An SQL statement to do this might look like the following:
SELECT Top 20 *
FROM YourTable
ORDER BY EntryDateTimeField, PrimaryKeyField



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Kevin wrote:
Hi,

how to get the last 20 rows only in one column contain 1000 rows
.