<div>
Thank you very much - that worked perfectly.
</div>


Thank you very much - that worked perfectly.

<div>
<div class="content wysiwyg-content">
I have a table containing the following<br />
<br />
&nbsp; Acct # &nbsp; &nbsp; &nbsp; Collection Date/Time &nbsp; &nbsp; &nbsp; Result Date/Time &nbsp; &nbsp; &nbsp; Clinical Event<br />
000005 &nbsp; &nbsp; &nbsp; &nbsp;1/1/2014 00:10:00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2014 00:42:00 &nbsp; &nbsp; Troponin-T<br />
000005 &nbsp; &nbsp; &nbsp; &nbsp;1/1/2014 00:15:00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2014 00:20:00 &nbsp; &nbsp; Troponin-I<br />
000005 &nbsp; &nbsp; &nbsp; &nbsp;1/1/2014 01:30:00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/1/2014 02:10:00 &nbsp; &nbsp; Troponin-T<br />
001002 &nbsp; &nbsp; &nbsp; &nbsp;1/3/2014 23:59:00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/4/2014 00:45:00 &nbsp; &nbsp; Troponin-T<br />
001002 &nbsp; &nbsp; &nbsp; &nbsp;1/4/2014 05:20:00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1/4/2014 05:25:00 &nbsp; &nbsp; Troponin-I<br />
<br />
I need a query that would pull the entire record with the earliest result time for each account. &nbsp;<br />
<br />
For Acct # 0005, I need the record with result date/time of 1/1/2014 00:20:00 (2nd rec)<br />
For Acct # 1002, I need the record with result date/time of 1/4/2014 00:45:00 (4th rec)
</div>
</div>


I have a table containing the following

  Acct #       Collection Date/Time       Result Date/Time       Clinical Event
000005        1/1/2014 00:10:00           1/1/2014 00:42:00     Troponin-T
000005        1/1/2014 00:15:00           1/1/2014 00:20:00     Troponin-I
000005        1/1/2014 01:30:00           1/1/2014 02:10:00     Troponin-T
001002        1/3/2014 23:59:00           1/4/2014 00:45:00     Troponin-T
001002        1/4/2014 05:20:00           1/4/2014 05:25:00     Troponin-I

I need a query that would pull the entire record with the earliest result time for each account.  

For Acct # 0005, I need the record with result date/time of 1/1/2014 00:20:00 (2nd rec)
For Acct # 1002, I need the record with result date/time of 1/4/2014 00:45:00 (4th rec)

extract records with the smallest value per group

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.