Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select only the last 40 records

Status
Not open for further replies.
LouisC4

LouisC4

Programmer
Jul 26, 2003
54
US
Hi All,

Is there a way to do an SQL SELECT to select only the last 40 records of a table?

TIA,

Louis
 
Sort by date Sort by votes
This should work provided there are no deleted records in the table:

select * from Table where recno() > (reccount() -40)

Darrell
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SitesMasstec
  • Locked
  • Question
Report not showing selected records 2
Replies
12
Views
802
Chriss Miller
C
Rajesh Karunakaran
  • Locked
  • Question
Select 1st record for each 'code' in table with multiple records for each 'code'
Replies
6
Views
640
Rajesh Karunakaran
Rajesh Karunakaran
Filip Brnic
  • Locked
  • Question
Automatically append last value + 1 into the textbox 1
Replies
12
Views
789
Chris Miller
Chris Miller
foxup
  • Locked
  • Solved
numeric equivalent of space() in select 1
Replies
13
Views
859
Chriss Miller
C
foxmuldr3
  • Locked
  • Question
Dropdown won't select with mouse, only keyboard
2
Replies
28
Views
1K
foxmuldr3
foxmuldr3

Part and Inventory Search

Sponsor

Back
Top