Select Statement 2

[Ablecken]

All I want to do is select the last 5 records of a table. I know that this selects the first five:
SELECT TOP 5 <FIELDNAME> FROM <TABLENAME>
If I change the TOP to BOTTOM it gives me an error. Bottom is probably not correct. If anybody can help me I'll be very grateful.
Thanx
Able

 

[tlbroadbent]

SELECT TOP 5 <FIELDNAME> FROM <TABLENAME>
ORDER BY <FIELDNAME> DESC
Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[Cagliostro]

try order by xxx dec John Fill

ivfmd@mail.md

 

[Ablecken]

I tried that but it still only gives me the first 5. I need the LAST five. Thanks a lot guys.
Able

 

[tlbroadbent]

Which database program are you using? Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[Ablecken]

I am acutally writing an asp script. Using an Access db. (Don't laugh
Able

 

[Cagliostro]

change order by, so as you to get from the last to first. In this case top will get the last records instead of first. John Fill

ivfmd@mail.md

 

[tlbroadbent]

Please post your SQL statement. I just ran a query in Access 2000 and got the correct result. My query is

SELECT TOP 5 Employees.EmpID
FROM Employees
ORDER BY Employees.EmpID DESC;
Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[Ablecken]

Thanks a lot. It worked. I must have been typing it wrong before.
Able