Multiple queries one report, no record source?

[lda via AccessMonster.com]

Hello,
I have made mulptile simliar queries that different based on the field [test]
or [method].

Each query needs to make a report based on the type of field selected. Is it
possible to have one report based off a multiple of queries.

Is it possible to have a report with all "subreports" and only the report
that matches the [test] or [method] is printed and available for view???


Thanks

LDA

SELECT SampleDetails.SampleNumber, Orders.CustomerID, SampleDetails.Matrix,
OrderDetails.Site, SampleDetails.DueDate, OrderDetails.CustomerSampleNumber,
Orders.ShippingMethod, ([sampledetails].[DueDate]-Date()-2) AS Daystodo,
QCBatch_RunSequence.QCBatchID, SampleDetails.OrderID, SampleDetails.Test
FROM QCBatch_RunSequence RIGHT JOIN ((SampleDetails LEFT JOIN Orders ON
SampleDetails.OrderID = Orders.OrderID) LEFT JOIN OrderDetails ON
(SampleDetails.SampleNumber = OrderDetails.SampleNumber) AND (SampleDetails.
OrderID = OrderDetails.OrderID)) ON QCBatch_RunSequence.SampleNumber =
SampleDetails.SampleNumber
WHERE (((SampleDetails.Test) Like "ims*"));

 

[Duane Hookom]

If the queries are very similar, you could possibly create a union query from
them and use this as the record source of a report. Also, a report can
contain multiple subreports. You may want to have a record source for the
main report so it is easier to set up the Link Master/Child properties.