Report From two Querys

[Bvincey2002]

I am trying to create a report from two separate querys. All my data works off of one table. My table consists of Large Retailers and Distributor Order information. I am trying create a report that will give me the aggragate for each catagory. I am running seperate quarys for each catagory to aquire the aggragate units and Dollar value for each catagory. I have all the information in the querys but I cannot create a report because they are running off of multiple querys. Do I need to create a single query pulling that information then place it in a report? I am a a very very beginner beginner, so please try to answer as simply as possible. Thank you!

[JoeM]

I think what you want is a Subreport. Basically, you create two Reports, and imbed one report inside the other, linking on some common field(s).
Here is a link on Subreports: http://office.microsoft.com/en-us/ac...010209281.aspx
There are also some good tutorials on YouTube. Just do a Google Search on "Subreports in Microsoft Access".

[Dal Jeanis]

If you need more specific guidance, then post the SQL from the queries here, and tell us what you want the report to look like.