Report based on many queries vs based on SQL

[desperatemeasures]

I currently have a report based on many queries as each query is limiting on different criteria and producing different information (Similar to a cross tab report). It isnt working that well as there are about 10 queries already and I have to add a few more fields. Is there any way of creating and unbound report with many textboxes on it and coding each field using SQL. I have tried it, by putting the select statement in the controlsource of each text box, but I get #Name as a result.

Any ideas or suggestions?

 

[CosmoKramer]

Try creating a report for each query and inserting each of these reports as subreports in one main report.

 

[desperatemeasures]

Thanks for that, but I was trying to avoid using subreports. I dont want to base the report on queries at all, as there would be over 10. I want to write SQL for each field on the report but dont know how to do this.