I have what I would have thought would be a very simple task to solve and I just can't figure it out. I have a table of inventory records. I want to do a query to limit the output to just 15 records per item. The fields in the table are
ItemNumber PalletNumber
This table has ten to twenty different Item numbers and could be up to hundreds of pallets of each one. I am trying to create a query to group by item number and then only show me the top 15 records for each item number. When I say the top 15 records that would be determined by the pallet number as they are all in numaric order.
I have search through the form and either I not searching for the right words or the answer is just not out here.
I am not very familier with VB, it would be great if there was a solution that I could do in the query build grid.
Thanks in advance for any help.
ItemNumber PalletNumber
This table has ten to twenty different Item numbers and could be up to hundreds of pallets of each one. I am trying to create a query to group by item number and then only show me the top 15 records for each item number. When I say the top 15 records that would be determined by the pallet number as they are all in numaric order.
I have search through the form and either I not searching for the right words or the answer is just not out here.
I am not very familier with VB, it would be great if there was a solution that I could do in the query build grid.
Thanks in advance for any help.