K
Kevin
Hi,
how to get the last 20 rows only in one column contain 1000 rows
how to get the last 20 rows only in one column contain 1000 rows
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Spencer
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
'====================================================
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
'====================================================
K
Kevin
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
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
J
John Spencer
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 sheet
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
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 sheet
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