Newbie needs help! Summary querries from multiple queries.

[Mat]

Hello, I have created a timecard database, my first, for
tracking of peoples time on projects with work code time
breakdowns. eg. on job X what was the total design time
etc... I have most of the reports done which I need but I
cannot figure out how sum together the results of
multiple summary queries. EG. Query #1, total CNC machine
run time. Query #2 total EDM run time. Query #3 total CNC
rework run time.

Each query works fine on its own giving me the correct
totals. But now I need to simply have these 3 totals
added together so I do not have to run the 3 reports &
manually add them. I have this kind of issue for various
reports.

When I try to create a summary query which uses these 3
queries then I get the error. "you have chosen fields
from record sources which the wizrd cannot connect. You
may have chosen fields from a table and a query based on
that table. If so try choosing fields from only the table
or only the query."

I don't know how to go about this. Can some please
help????? I would have attached the DB but its too large.

Thanks to all!!