If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
querying the data
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 |
#2
|
|||
|
|||
querying the data
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. -- Duane Hookom Microsoft Access MVP "cliff" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|