<div>
The LIMIT function in SQL limits the total number of records returned by the query, it can't be used to limit the number of records that match a sub query.<br />
<br />
You would need to do it with an initial query that gets you the PartNo's and then loop through the part numbers to get the top 3 records for each part number.<br />
<br />
What do you mean by top 3 by the way? largest Recnum, or something else?
</div>


The LIMIT function in SQL limits the total number of records returned by the query, it can't be used to limit the number of records that match a sub query.

You would need to do it with an initial query that gets you the PartNo's and then loop through the part numbers to get the top 3 records for each part number.

What do you mean by top 3 by the way? largest Recnum, or something else?

<div>
<div class="content wysiwyg-content">
I have a table named tblOpenOrders. &nbsp;The primary key field is named RecID. &nbsp;Also in the table is a field named Part_No. &nbsp;I am trying to write a query using query designer that finds the top three records in the table, with RecID being a number field FOR EACH part in Part_No.<br />
<br />
So the resulting query might look like:<br />
<br />
Part_No &nbsp; &nbsp; &nbsp; RecID<br />
12345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;98234<br />
12345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;97620<br />
12345 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;97100<br />
45612 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;99124<br />
45612 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;99005<br />
45612 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;98307<br />
78451 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;97890<br />
78451 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;96120 &nbsp;(sometimes there could be only 2 or 3 records for a given Part_No)<br />
etc.<br />
etc.<br />
etc.
</div>
</div>


I have a table named tblOpenOrders.  The primary key field is named RecID.  Also in the table is a field named Part_No.  I am trying to write a query using query designer that finds the top three records in the table, with RecID being a number field FOR EACH part in Part_No.

So the resulting query might look like:

Part_No       RecID
12345          98234
12345          97620
12345          97100
45612          99124
45612          99005
45612          98307
78451          97890
78451          96120  (sometimes there could be only 2 or 3 records for a given Part_No)
etc.
etc.
etc.

How find top 3 records for each part number

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.