querying the data

[cliff]

thnaks Mr.Douglous for help I got from you for last question, really your
answer worked well to solve my problem . Now I have another problem

My data is no1. no2. no.3 no.4 no.5
2 9 13 17 20
4 13 21 30 31
4 9 17 26 27
9 10 13 19 29
9 17 20 26 27
2 13 17 26 30


Now I want to create report/query on the above data to find out no. of
pairs/triples etc like
9 13 appeared twice in pair
13 17 appeared twice in pair
17 26 appeared thrice in pair
9 17 20 appeared twice in triples
2 13 17 appeared twice in triples
9 17 26 27 appeared twice in 4 nos.

coud you help me to solve this problem?. I tried query of say no.1 & no.2
then no1. and no.3 then no1.no.4 etc, but I could not merge my query results
into one table or query

cliff

 

[Duane Hookom]

Is the data you described the actual table structure or the result of a
crosstab? Is there a primary key field that you aren't showing us (there
should be)? How would you want the result to actually display? What are the
table/query names?

If the data is actually structure as provided, you will probably need a
union query.