<div>
That's not possible. SELECT TOP 1 must always return (at most) one record.<br />
<br />
Would you mind posting the SQL for the actual query you are using?
</div>


<div>
Multiple users have nothing to do with how TOP 1 works.<br />
<br />
/gustav
</div>


<div>
Top N is based on the sorted field. &nbsp;It will return all records with the same date value if the first date occurs on multiple records.<br />
<br />
If there is no sort field its anybody's guess what you will get.
</div>


<div>
Peter might be on the right track. &nbsp;Is there any way to narrow that down to one single record, though?<br />
<br />
I'll post the whole SQL if I don't have an answer that works by the time I get back to my office.<br />
<br />
Thanks!
</div>


<div>
Excellent!<br />
<br />
That did it. &nbsp;I knew it would be something simple like that.<br />
<br />
Thanks!
</div>


<div>
<div class="content wysiwyg-content">
I have a query where I am simply trying to get a single record returned from a table. &nbsp;The following is very similar to what I have. &nbsp;There are 145 items in the table, and it pulls all 145 instead of the first entry.<br />
<br />
I have an ORDER BY statement (excluded) that sorts by date received for me. &nbsp;The idea is to funnel these items into a bucket and pull them one by one. &nbsp;Need the SELECT TOP 1 query as multiple users are working out of this at the same time.<br />
<br />
SELECT TOP 1 tbl_Master_Items.FieldName<wbr />, tbl_Master_Items.FieldName<wbr />, tbl_Master_Items.FieldName<wbr />, tbl_Master_Items.FieldName<wbr />, tbl_Master_Items.FieldName<wbr />, tbl_Master_Items.FieldName<wbr />, tbl_Master_Items.FieldName<wbr />, tbl_Master_Items.FieldName<wbr />, tbl_Master_Items.FieldName<wbr /><br />
FROM tbl_Master_Items
</div>
</div>


I have a query where I am simply trying to get a single record returned from a table.  The following is very similar to what I have.  There are 145 items in the table, and it pulls all 145 instead of the first entry.

I have an ORDER BY statement (excluded) that sorts by date received for me.  The idea is to funnel these items into a bucket and pull them one by one.  Need the SELECT TOP 1 query as multiple users are working out of this at the same time.

SELECT TOP 1 tbl_Master_Items.FieldName, tbl_Master_Items.FieldName, tbl_Master_Items.FieldName, tbl_Master_Items.FieldName, tbl_Master_Items.FieldName, tbl_Master_Items.FieldName, tbl_Master_Items.FieldName, tbl_Master_Items.FieldName, tbl_Master_Items.FieldName
FROM tbl_Master_Items

Problem with SELECT TOP 1 query

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.

Microsoft Access

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.