<div>
SELECT Name, Nz(Salescode,&quot;none&quot;) As Saves_Code, Max(Date) FROM QuickenTrxList Group By Name, Nz(Salescode,&quot;none&quot;) Order By Name<br />
<br />
Mike
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a transaction journal file with customer sales and related information.<br />
<br />
One field is a sales code, which can change overtime, and isn't always entered (it should be mandatory input but currently isn't). &nbsp;I need to come up with a query that gives me a Name and the sales code from the latest dated transaction in the case where there is one, or &quot;none&quot; if there isn't one at all in any of the transactions for that company.<br />
<br />
I have attempted a subquery with max(date) but it is taking forever to run....<br />
<br />
This is what I have currently:<br />
<br />
SELECT QTL.Name, QTL.Salescode<br />
FROM QuickenTrxList AS QTL<br />
WHERE (((QTL.Date)=(SELECT Max(Date) From QuickenTrxList as S WHERE S.Name = QTL.Name )));<br />
<br />
Deedub<br />

</div>
</div>


Hi Experts,

I have a transaction journal file with customer sales and related information.

One field is a sales code, which can change overtime, and isn't always entered (it should be mandatory input but currently isn't).  I need to come up with a query that gives me a Name and the sales code from the latest dated transaction in the case where there is one, or "none" if there isn't one at all in any of the transactions for that company.

I have attempted a subquery with max(date) but it is taking forever to run....

This is what I have currently:

SELECT QTL.Name, QTL.Salescode
FROM QuickenTrxList AS QTL
WHERE (((QTL.Date)=(SELECT Max(Date) From QuickenTrxList as S WHERE S.Name = QTL.Name )));

Deedub


SELECT Name, Nz(Salescode,&quot;none&quot;) As Saves_Code, Max(Date) FROM QuickenTrxList Group By Name, Nz(Salescode,&quot;none&quot;) Order By Name

Mike

Subquery to get max(date) from transaction file by customer

Hi Experts,

I have a transaction journal file with customer sales and related information.

One field is a sales code, which can change overtime, and isn&#39;t always entered (it should be mandatory input but currently isn&#39;t).  I need to come up with a query that gives me a Name and the sales code from the latest dated transaction in the case where there is one, or &quot;none&quot; if there isn&#39;t one at all in any of the transactions for that company.

I have attempted a subquery with max(date) but it is taking forever to run....

This is what I have currently:

SELECT QTL.Name, QTL.Salescode
FROM QuickenTrxList AS QTL
WHERE (((QTL.Date)=(SELECT Max(Date) From QuickenTrxList as S WHERE S.Name = QTL.Name )));

Deedub


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.