kind of at wits end on this one.

[GaryB]

Hi all,

I am trying to create a report that encompasses 3 queries into one report. I am hitting conflicts for all directions. I could really use come direction on what I have to do to make this possible, if it is possible at all.

Thanks to anyone who responds to this thread,

Gary:banghead:

[orange]

You have provided NO DETAILS. We need info if we are to help.

[GaryB]

My apologies.....
I have a query 1 and report 1 that is the starting point for A
When the work on A it is clicked completed and no longer appears on 1 but does now appear on query 2 and report 2
When the work on A is again completed it clicked on and no longer is appears on 2 but is visible
on query 3 and report 3 which is bindery and shipping information.

Currently one of the managers is printing out all 3 reports and pasting them together and the copying the collage and passing it out to the employees. Obviously is changes daily as items work through the system a this combined report he is creating shows each department where a particular component is in the process. What I have been asked to do is create a report that shows all 3 reports on one sheet to eliminate the cutting and pasting. I have tried, but, because each query has different variables I can't seem to create the report I need.