Multiple results query

[IannWard]

Hi



How do I create a report based on the results from multiple queries?


Thanks in advance..

[JoeM]

One way is to put each result in a Subreport, and place all the Subreports in your final Report.
See: https://support.office.com/en-us/art...0-ce817093bb33

[IannWard]

Each of my queries returns a list of serial numbers with a total at the bottom. Is all I want is the totals from each query rather than the lists of serial numbers.

[JoeM]

If all your queries follow the same structure, you can combine all the queries together in a single query using a Union Query.
See: https://support.office.com/en-us/art...rs=en-US&ad=US

[June7]

Could one aggregate query possibly achieve the same output?

[kagoodwin13]

It's really hard to tell what you need without an example of your data. Could you provide us with an example of your raw data, and your desired report output? Make an example Excel file, save as a zip file, and attach it to a post. (Scrub it for proprietary data, of course.)

What you might be looking for is a cross-tab query. Here is a simple explanation of a crosstab query: http://www.fmsinc.com/Microsoftacces...ort/index.html

You might also be looking for a union query. If you have multiple queries which all have the same exact columns, and you want to intertwine the results, that is what a union query can do. Here is a simple explanation of a union query: http://www.fabalou.com/access/queries/unionquery.asp