<div>
if you have unique identifier for action table then set the &quot;total&quot; to Max
</div>


if you have unique identifier for action table then set the "total" to Max

<div>
<div class="content wysiwyg-content">
I have 2 tables. &nbsp;The 1st is system and the second is actions. &nbsp;The relationship is multiple records from the actions table for every record in the system table. &nbsp;I want to run a query selecting all the data from the system table and only the last action from the action table. &nbsp;I have a date field in the action table. &nbsp;Is this possible? How can I do this?<br />
<br />
Marilyn
</div>
</div>


I have 2 tables.  The 1st is system and the second is actions.  The relationship is multiple records from the actions table for every record in the system table.  I want to run a query selecting all the data from the system table and only the last action from the action table.  I have a date field in the action table.  Is this possible? How can I do this?

Marilyn

How do I select the last record of a group in MS Access

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.