Select last record from MS Access database

[MARKAND911]

How to use TOP(1) keyword in MS Access query.

select * TOP(1) from mytable orderby mycolumn desc;

this querry gives me error;

Any other alternate to implement this code;

[priyasudhakar]

Please use this query for selecting last record
select top 1 * from table_name order by columnname desc
if the columnname is id of the table
BY
priyasudhakar