selecting records from various tables

[cliff]

Hi, I am new to access. I have small problem and look forward help from
experts

I have three gropus of data based on certian conditions and I want select
few records from each groups together at one shot . How do I do that :

group 1:-

numvalue 48 66 40 55 64 76 50
group 2 :-
numvalue 18 21 36 30 1 16 34 11 20
group 3:-
numvalue 45 72 43 52 61 70 79 62 68

Now I want to select total 10 records from all 3 , but I want to select 3
each from group One and Group 2 and 4 from group 3. Again I want to select
5 from group 3 and 3 from group 2 and 2 from group 1. In short I want to
select 10, but in different group combination say 4 from 1,4 from 2 and 2
from group 3 etc.


Please help to solve this

clifrichards

 

[KARL DEWEY]

Use a TOP X in union query.

If this is not enoigh information for you to do it then post the table and
field names with what constitutes each group.