Hi,
I'm trying to create a report containing data from many queries, but Access will not let me do it, since the queries are not linked together.
The database is a questionaire. It's asking for male/female and which age from 3 pre-defined groups. After that there's 4 yes/no questions. Based on this, I want to make a report viewing how many answered Yes on question A, how many women answered yes/how many men, how old they were etc.
I made queries to give the number of how many women answered yes, how old they were etc. Now the problem is to create a report. If I try to create a report using the wizard, I get an error message when trying to select more than one query. Something about the wizard can't connect the record sources. But I only want to have the number returned by the query, so there's no need to connect any tables/queries etc.
Anyone know how I can solve this?
Regards,
Gandi
I'm trying to create a report containing data from many queries, but Access will not let me do it, since the queries are not linked together.
The database is a questionaire. It's asking for male/female and which age from 3 pre-defined groups. After that there's 4 yes/no questions. Based on this, I want to make a report viewing how many answered Yes on question A, how many women answered yes/how many men, how old they were etc.
I made queries to give the number of how many women answered yes, how old they were etc. Now the problem is to create a report. If I try to create a report using the wizard, I get an error message when trying to select more than one query. Something about the wizard can't connect the record sources. But I only want to have the number returned by the query, so there's no need to connect any tables/queries etc.
Anyone know how I can solve this?
Regards,
Gandi