Hi,

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:

Date Artikelnumber
02/05/2007 1
02/05/2007 3
02/05/2007 12
02/05/2007 15
02/05/2007 16
02/05/2007 19
02/05/2007 30
02/05/2007 46
02/05/2007 58

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?

Already found a solution myself...