<div>
Spot on, worked perfectly. Many thanks!
</div>


<div>
<div class="content wysiwyg-content">
I have some SQL running on an ASP page that uses the SELECT LAST query, to select the last record of a few fields where a condition on a certain field/s is true (from an MS Access database).<br />
<br />
Up until recently, this was working fine. But I am now seeing some odd behaviour. The query is not selecting the last record for the given condition, neither is it necessarily selecting the first. Sometimes it may be the second (based on the ID field - primary key) record that meets the condition, etc.<br />
<br />
As a workaround, I have used SELECT MAX on the ID field where the conditions are true, and run another query based on this result but this is a messy way of doing this based on the rest of my ASP page.<br />
<br />
Any help appreciated!
</div>
</div>


I have some SQL running on an ASP page that uses the SELECT LAST query, to select the last record of a few fields where a condition on a certain field/s is true (from an MS Access database).

Up until recently, this was working fine. But I am now seeing some odd behaviour. The query is not selecting the last record for the given condition, neither is it necessarily selecting the first. Sometimes it may be the second (based on the ID field - primary key) record that meets the condition, etc.

As a workaround, I have used SELECT MAX on the ID field where the conditions are true, and run another query based on this result but this is a messy way of doing this based on the rest of my ASP page.

Any help appreciated!

SQL SELECT LAST does not return the last record

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.