Finding the lastest date among several records

[Jackie]

I have a table that stores SSN and date.&nbsp;&nbsp;Multiple records exist for an SSN. For each SSN, I want to select the record with the lastest date.&nbsp;&nbsp;I suspect this is a situation for an array, but am not fond of arrays.&nbsp;&nbsp;Any thoughts (even if it means using an array) would be appreciated.<br><br>Thanks.

 

[DougP]

I guees your data is in a table right?<br>Use a query.<br>Add the SSN number and type this in the criteria box<br>[Enter Social Security #] <br>&nbsp;Brackets and all.<br>Then add the Date field and any other fields you want.<br>In the Date field click in the Sort column and pick Descending.<br><br>Run your query (click RED Exclamation mark) in menu bar.<br>The key in a valid SSN number and press enter. The latest date will be on top.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Cornerstone]

If you only want to see the last date record then make the query a Totals query, and set the SS field to Group By and the Date field to Max.

 

[Jackie]

Since this data is for a report and all ssn's need to be included in the report, a parameter query won't work.&nbsp;&nbsp;The Totals query approach might be the answer.&nbsp;&nbsp;Thanks for the responses.