Using multiple queries in a Report.

[Adzi]

I've got a database with ~420 records containing multiple choice answers from a surevey we conducted over the christmas time. I've really just only got round to compiling the data so I can hand it in to head office. So basically what i've done is created a query for each of the questions (7 in total) in the following structure...

The same structure is used for the following questions.

Whenever I try and pop the questions into a report I get an error.

Is there anyway to get the seven queries into the report? or a better way of designing the query?

Help is greatly appreciated

 

[rainman89]

I see a problem with your design..... but since u have already conducted the survey and have all the info... its probably too late.

Have u tried putting subreports into your main report for the different queries?

 

[Adzi]

I really dont want to have to re-enter 400 odd survey forms if possible. I'm not all familiar with sub-reports etc. I'll have a hunt aroun in access help for some info.

 

[rainman89]

a subreport is just like a subform. create a report for each of the 7 queries. drag them into your main report and link them(or dont) if needed.

 

[Adzi]

ok, i'll have a go ! Thanks!

 

[Dennisk]

if each query only return one row then you can place them all in one single query.

 

[Adzi]

if each query only return one row then you can place them all in one single query.

My queries have to return the count of the number in each selection.
e.g.
Was the venue appropriate?
Aggree - 350
Disagree - 21
Dont Know - 49

The way I designed my table is to have each questionnaire in one row. Probably not the best planning but I wasnt really paying much attention while doing it.