<div>
Thanks, but why Last Not working. &nbsp;Max, is good
</div>


Thanks, but why Last Not working.  Max, is good

<div>
<div class="content wysiwyg-content">
Can you tell what's wrong with the query:<br />
<br />
SELECT First([THREE-OR-MORE-MRTG]<wbr />.[T-Loan-N<wbr />o]) AS FirstLoan, First([THREE-OR-MORE-MRTG]<wbr />.[MRTG-NO]<wbr />) AS GrpNumber<br />
FROM [THREE-OR-MORE-MRTG]<br />
GROUP BY [THREE-OR-MORE-MRTG].[T-DS<wbr />C-USE], [THREE-OR-MORE-MRTG].[MRTG<wbr />-NO];<br />
<br />
I have following data<br />
<br />
T-Loan-No &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MRTG-NO<br />
250821 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25<br />
250834 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25<br />
250847 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 25<br />
270157 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25<br />
271127 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25<br />
271130 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25<br />
<br />
anytime, i'm trying to pickup last loan in this group it picks 270157 instead of 271130 which I do need
</div>
</div>


Can you tell what's wrong with the query:

SELECT First([THREE-OR-MORE-MRTG].[T-Loan-No]) AS FirstLoan, First([THREE-OR-MORE-MRTG].[MRTG-NO]) AS GrpNumber
FROM [THREE-OR-MORE-MRTG]
GROUP BY [THREE-OR-MORE-MRTG].[T-DSC-USE], [THREE-OR-MORE-MRTG].[MRTG-NO];

I have following data

T-Loan-No                          MRTG-NO
250821                                 25
250834                                 25
250847                                 25
270157                                  25
271127                                  25
271130                                  25

anytime, i'm trying to pickup last loan in this group it picks 270157 instead of 271130 which I do need

sql code

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.