results shown by query
Is it possible to create a query were you can limit (or choose) the number of responses the query gives you.
Let me explain:
I have a table 'table1' with the fields 'Date' and 'Artikelnumber'. What I would like to do know is that I want to make different query's to obtain a number of results I want.
If in the table I have the records:
Then I would build 3 different query's that give me as result a group of 3 records everytime. So the first query should give me the artikelnumbers 1, 3 and 12. The second one 15, 16 and 19 and the thirth one 30, 46 and 58.
I know I can work with top value's and top % in a query, but here I can't use these, because the first query should return me the first 3 values, the second one value 4 till 6 and the last one value 7 till 9.
Can this be done with a query or not?