Can I merge multiple queries into a report? Or can I extract data from multiple queries into a report? I've tried using the wizard to include all data from all queries into a report but unable to do so. The error states that I have chosen from a table and a query, but I've only chosen from the queries.

Any suggestions?

Create a new query that joins the two existing queries and use the new query as the recordsource for the report.

You can do as Pat suggests or make a new report on your 2 nd 3rd and 4th query etc, but include them as sub reports joined buy the appropriate variables.