<div>
What do you want to achieve y using LAST()? Do you run it in Access or SQL Server?
</div>


<div>
I think I tried, but I will again.<br />
Thank you.
</div>


<div>
I want the most recent transaction record on a part.
</div>


<div>
Max gives me the same number of records each time.<br />
If max is the solution to display the most recent record for inventory transaction, this is the solution.<br />
<br />
Thank you.
</div>


<div>
Thank you, max solved the issue.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
I am puzzled.<br />
This query:<br />
<br />
SELECT DISTINCTROW Last(dbo_INVENTORY_TRANS.T<wbr />RANSACTION<wbr />_DATE) AS LastOfTRANSACTION_DATE, dbo_INVENTORY_TRANS.PART_I<wbr />D<br />
FROM dbo_INVENTORY_TRANS<br />
GROUP BY dbo_INVENTORY_TRANS.PART_I<wbr />D<br />
HAVING (((Last(dbo_INVENTORY_TRAN<wbr />S.TRANSACT<wbr />ION_DATE))<wbr />&gt;#12/31/20<wbr />12#) AND ((dbo_INVENTORY_TRANS.PART<wbr />_ID) Is Not Null))<br />
ORDER BY Last(dbo_INVENTORY_TRANS.T<wbr />RANSACTION<wbr />_DATE) DESC , dbo_INVENTORY_TRANS.PART_I<wbr />D;<br />
<br />
gives me different results each time I click Run.<br />
The database is linked using ODBC to our ERP database. Nobody is logged in to the ERP, so no transactions are going on.<br />
Difference between each time can come to almost thousand records.<br />
<br />
What am I doing wrong?<br />
<br />
Microsoft Access 2013. SQL Server 2007.
</div>
</div>


Hello,
I am puzzled.
This query:

SELECT DISTINCTROW Last(dbo_INVENTORY_TRANS.TRANSACTION_DATE) AS LastOfTRANSACTION_DATE, dbo_INVENTORY_TRANS.PART_ID
FROM dbo_INVENTORY_TRANS
GROUP BY dbo_INVENTORY_TRANS.PART_ID
HAVING (((Last(dbo_INVENTORY_TRANS.TRANSACTION_DATE))>#12/31/2012#) AND ((dbo_INVENTORY_TRANS.PART_ID) Is Not Null))
ORDER BY Last(dbo_INVENTORY_TRANS.TRANSACTION_DATE) DESC , dbo_INVENTORY_TRANS.PART_ID;

gives me different results each time I click Run.
The database is linked using ODBC to our ERP database. Nobody is logged in to the ERP, so no transactions are going on.
Difference between each time can come to almost thousand records.

What am I doing wrong?

Microsoft Access 2013. SQL Server 2007.

MS Access returns different results each time

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.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.