Multiple requests on a report, from two queries... 2

[girlieneedshelp]

I am trying to do a multiple request for a report. I am using two queries.
One is from my customer table.
The first query I want to get on the report is the customer name, number, balance due and balance paid from all customers.
The second query I want on the same report are only the customers of driver 121 who have a balance still
The third query for the report is the total amount paid for each sales rep.

I keep getting a message saying that I am using a table and a query, but I am using both query results..
any ideas? or should I put it on two reports?

 

[Moxy1]

Have you tried using a sub report?

 

[girlieneedshelp]

Yes, I did consider that...but wasnt sure if it was appropriate for this application.

I would just like it to appear like


Total Customer income: $xxxx

Total Salaries for drivers $ xxxxxxx

Total income for driver 121 $xxxxx
(this driver has done over 2 x what my other drivers have done and I want to be sure he gets compensated for his excellence in service)

 

[melisc]

Have you tried making one query out of the three tables and linking them together. Only include in that query the data you need for your report. Then you can build one report off of a single query.