B
Basil
Hiya
Having a bit (lot) of trouble with making a report from a crosstab
I am doing a database that is similar in structure to Duane Hookom's AtYourSurvey. In Duane's bad boy he has a cross-question comparison report - which is actually a crosstab query in datasheet view. I am trying to do something the same, but get these results in a report (I wanted to add graphs etc below it)
My issue, is that I do not always know how many columns (responses) there will be for a question. I've looked at the invisibleinc site with the view that I can count the columns through some sql trick or something, but it boggled me a bit (lot)
Has anyone attempted this/is there any example (have you ever tackled this in AtYourSurvey Duane?)
I'd really appreciate any advice
Thanks loads
Basil
Having a bit (lot) of trouble with making a report from a crosstab
I am doing a database that is similar in structure to Duane Hookom's AtYourSurvey. In Duane's bad boy he has a cross-question comparison report - which is actually a crosstab query in datasheet view. I am trying to do something the same, but get these results in a report (I wanted to add graphs etc below it)
My issue, is that I do not always know how many columns (responses) there will be for a question. I've looked at the invisibleinc site with the view that I can count the columns through some sql trick or something, but it boggled me a bit (lot)
Has anyone attempted this/is there any example (have you ever tackled this in AtYourSurvey Duane?)
I'd really appreciate any advice
Thanks loads
Basil