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:
78451 96120 (sometimes there could be only 2 or 3 records for a given Part_No)