Sub Reports using queries which aren't linked

[ryadav]

Hi

I want to create a report which includes information from different queries. I have tried to add more than one query to a report but it comes up with the following:

'You have chosen fields from record sources which wizard can't connect. You may have chosen fields from a table and a query based on that table. If so try choosing fields from the only the table or query.'

The queries are not linked but include the same fields as each other. Each query returns information for a specific week. Therefore, I am trying to create a report which includes a summary of all the weeks.

Can you please advise?

thanks

 

[boblarson]

You can create sub reports for each of the queries and then put them in a master report with no recordsource and without setting a link between the master and subreports. You probably have to do this manually and not by using the reports wizard.

 

[Joe8915]

search this form using the key word "hasdata"