report from more then 1 querie

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a report compairing two queries. One querie has data
in it from multiple clients (Data Querie) and the other is the average of
each line item being compaired in the data querie. How can i create a report
with those two columns. I can't seem to create a relationship between them.
 
We "can't seem to create a relationship between them" either because we
don't have a clue regarding your table structures, queries, sample
records,....
 
Is there a way to structure my table and queries to make it so i can create
this relationship/report? Right now i have a table with such fields at
number of employees and income. I have created a querie to calculate income
per employee for all my clients. i have also created a querie to calculate
the average of my clients income per employee. i would like to have a report
that i can show each one of my clients to compair their income per employee
to the rest of my clients.
 
I can't picture what you mean by "show each one of my clients to compair
their income per employee to the rest of my clients". Do you even know what
this would look like?

Maybe you could type a few records from your table and expected results?
 
My table looks like this:

Employees Net Income Etc...
Company A 10 158,757
Company B 7 169,587
Company C 6 143,002

One querie has:

Net Income Per Employee Etc...
Company A 15,875.70
Company B 24,226.71
Company C 23,833.67

Another querie has:

Average Net Income Per Employee
20,493.30

The report I want would have:

Company A Average
Net Income Per Employee 15,875.70 20,493.30
Etc...

Net Income per employee is only one of the many items i want to compair.
 
If there is only one record in the "Another querie" then you can add this
query to your report's record source query without any joins. Add the
Average field to the grid.
 
Back
Top