Combining Two Queries into One Report

[ardagh]

Is it possible to combine two queries into one report.

The information I need to report on is as follows

All yesterdays production. This will include the Lot#, operator, Date/Time, Customer, operation, qty, hrs, rejects.
I have a working query for this.

The second query is

All the historical data relating to any open orders. This should be ordered by lot number and should be displayed immediately underneath 'yesterday's results' where applicable - otherwise it should be displayed at the bottom of the report.

I have not come up with a way of closing an order. An order could be open for an hour, a day , a week , a year - until the production manager closes it. There may be hundreds of entries for each order (the order is given a lotno and is recognised by this in the system.

Any help/advice would be appreciated.

Niall

 

[hneal98]

It sounds like your first query would be the main report and the second query you would use to build a sub report.