How to use info from two reports

[slim shady]

I currently have two reports that help me to track productivity: one tracks
loading productivity and time, the other picking. We use the order number as
our primary key. The picker "ALEBLO" will not always load the same order. I
am trying to find a way to put this information together on one report that
will allow me to sum the total time spent picking and loading for each
operator.

 

[John Vinson]

I currently have two reports that help me to track productivity: one tracks
loading productivity and time, the other picking. We use the order number as
our primary key. The picker "ALEBLO" will not always load the same order. I
am trying to find a way to put this information together on one report that
will allow me to sum the total time spent picking and loading for each
operator.

Slim, you're assuming that we have more knowledge of your database
than you have posted.

I have NO idea what you mean by 'the picker "ALEBLO"' for example, nor
what an operator is (to me that means the = operator or the <>
operator or the LIKE operator).

It SOUNDS like you're trying to extract information from reports.
Reports don't contain information - they are a tool to PRINT
information, which is stored in your Tables. I'm guessing that you
need to construct an all-new report (salvaging some bits of your
existing reports), based on a new Query of your tables, but since I
have no idea how your data might be structured it's all but impossible
to advise.

John W. Vinson[MVP]

 

[slim shady]

Sorry, I have two queries one which tracks picking productivity the other
loading. In each of these queries the operator is selected by a drop down
box, "ALEBLO" represnts our abb. for their name. I want to make a report from
these two queries that will allow me to put together both the picking and
loading times for any operator.

 

[John Vinson]

Sorry, I have two queries one which tracks picking productivity the other
loading. In each of these queries the operator is selected by a drop down
box, "ALEBLO" represnts our abb. for their name. I want to make a report from
these two queries that will allow me to put together both the picking and
loading times for any operator.

One way to do so is to create an unbound Report with two Subreports,
one for each query. Or you might want to create a UNION query to
combind the data in the two queries - again, since I don't know
anything about the queries or the reports, it's hard to say which
might be simpler!

John W. Vinson[MVP]