Tying two queries to one report in Access 2000

[loo]

I need to use two queries to tie into one report... they come from different tables with subtotals and I need to combine the two but there doesn't seem to be a way via relationships.

I have a payroll table that has department worked by ID # with gross wages & hours worked.

I have a production table that has id # departments worked...

problem lies in I can't combine the two queries generated to give me the following:

ID # wages hours dept revenue (grouping by dept.)
because there is no wages associated for that dept. and vise versa..

So how do I tie two queries to one report via design view?

 

[Junior1544]

This pose should be in the Access Queries Forum...
forum701 probably wont get much help here...
but in the Access forum i just listed, there are people that are experts watching and answering questions there... They will be able to answer i'm sure...

--Junior Junior1544@yahoo.com
Life is change. To deny change is to deny life.

 

[JonJacobik]

I'd use VBA to create a program to create a new temporary database, use the output from each querry to populate the new db file, then generate the report. Time consuming, but it'd work.

 

[B827]

Do the ID # in the two tables refer to the same data - for example payroll numbers or are for different data? Sandy