selecting nos from table

[cliff]

Hi I am bit new to access. Suppose I want to choose Five Nos from the
following table
mytable
n1
14
18
23
34
38
35
16
17

but I want to put restriction selecting numbers the following nos

17,13,26,19,6 maximum Two can be selected
17,13,26,28,19 "
26,17,13,28,12 "
17,26,12,13,31 "
17,26,1,31,12 "
4,5,25,30,7,18,20,3,16,2,9,11,14,21,15,10,8,22, 9 minimum Two and Maximum
5 can be selected.

I want to save the nos met the above into the table.

I have the following query to select five nos from mytable

SELECT TOP 5 mytable.n1
FROM mytable
WHERE (((randomizer())=0))
ORDER BY Rnd(IsNull(mytable.n1)*0+1);

Can you hep to join the various criterias to the selected five nos. If all
criteria are fullfilled then I want to save the selected nos in group


thansk in advance

 

[KARL DEWEY]

Based on the data you posted it is impossible.
The only numbers in [mytable] that match those to select are 14, 16,and 17.