Hello.
Is it possible for a query to filter and sort the results and then just give me the first 5 results from the top of the list?
Its basically an allocation database and Ive got a table with loads of serial numbers that need putting in batches of 5, so I need the next 5 that havn't been allocated (ie. got a number in the batchID field) to come up in a form so I can put the same batchID to them, therefore making another batch of 5.
Sorry its hard to explain..but please help if you can.
Thanks a lot
Ross
Is it possible for a query to filter and sort the results and then just give me the first 5 results from the top of the list?
Its basically an allocation database and Ive got a table with loads of serial numbers that need putting in batches of 5, so I need the next 5 that havn't been allocated (ie. got a number in the batchID field) to come up in a form so I can put the same batchID to them, therefore making another batch of 5.
Sorry its hard to explain..but please help if you can.
Thanks a lot
Ross