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;

Re: Select last record from MS Access database 80 80

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.