select last 5 records only

[florida41]

I need to fetch just the last 5 records when I query my Access 2000 database:

select * from TableOne where project_id = 10;

If I have 10 hits on the above how can I make sure it just selects the last 5 records?

 

[PHV]

select top 5 * from TableOne where project_id = 10
order by yourSortField desc;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lespaul]

is there some way to tell which 5 you need? The ones with the largest ID number? The latest time? What is the criteria, just being the last 5 records entered into the table?



Leslie

 

[florida41]

The last 5 records so it would be the largest ID numbers.

 

[lespaul]

then change PHV's answer to

ORDER BY ID DESC

Leslie

 

[amorous]

select TOP 5 * from TableOne ORDER BY Project_Id DESC;

-VJ

 

[florida41]

Thanks everyone!