How to use many query in one report

[dododo]

I have many query and i wan to show alot of query in one report. How can i do that? I designed report by my own and want to bound it with many query. Please tell me how to do it.



Please see the link of my report. Each rows and columns of my report need to bound with one query.

http://postimage.org/image/xatfswas

[June7]

Show sample data. What do you mean by 'have many query'. A report can have only one RecordSource. A report can have subreports.

[dododo]

Please visit below link. It is my report list.

http://postimage.org/image/xatfswas

'Many Query' It means I want to connect my report with more than one query. I have about 30 query and want to connect all to one report.

How can i use subreport? If i want my report look like what i designed.

[June7]

That image doesn't help. Need to see data structure. A report cannot have more than one query as RecordSource. Depending on the structures of these queries, might be able to combine them by Join or Union into one query and then use that as the RecordSource. It is just bizarre that you have 30 queries for one report output. Look at Access Help for guidance on designing reports with subreports. Check this article http://office.microsoft.com/en-us/ac...005187409.aspx