Return top 5 records

[ozpeppers]

Hello all,

I'm trying to return the last 5 entered records into a table by:

SELECT TOP(5)
tbl_link.id
,tbl_link.title
,tbl_link.urlPath

FROM tbl_link

ORDER BY tbl_link.id DESC;

Access keeps throwing an error...

Does anyone know the correct code?

Thanks in advance

 

[CosmoKramer]

First, try getting rid of the parentheses:

SELECT TOP 5
        tbl_link.id
       ,tbl_link.title
       ,tbl_link.urlPath

FROM tbl_link

ORDER BY tbl_link.id DESC;

Second, you will have to include a date/time field in your order by clause to be able to return the 5 most recent records....

 

[ozpeppers]

Thanks CosmoFramer

Worked a treat!