Queries

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

Guest

I'm running into an issue of how to accomplish my goal. I trying to create a report that will show total sales for a facility and break that down into sales from salesmen outside of their own. I have two queries on that shows total sales by facility and one that shows sales by salement outside of their own. How can I get all this onto one report. Right know i have the report based on the query that shows sales for a facility outside of their own. I need a way to display total sales for the facility as a whole on the report. Any ideas?
 
Maybe to use a subdatasheet in your report?

Regards Herman
-----Original Message-----
I'm running into an issue of how to accomplish my goal.
Click to expand...
I trying to create a report that will show total sales for
a facility and break that down into sales from salesmen
outside of their own. I have two queries on that shows
total sales by facility and one that shows sales by
salement outside of their own. How can I get all this
onto one report. Right know i have the report based on
the query that shows sales for a facility outside of their
own. I need a way to display total sales for the facility
as a whole on the report. Any ideas?
 
I'm running into an issue of how to accomplish my goal. I trying to create a report that will show total sales for a facility and break that down into sales from salesmen outside of their own. I have two queries on that shows total sales by facility and one that shows sales by salement outside of their own. How can I get all this onto one report. Right know i have the report based on the query that shows sales for a facility outside of their own. I need a way to display total sales for the facility as a whole on the report. Any ideas?
Click to expand...

I'd suggest using an unbound Report with two Subreports, one for each
query.
 
How to I create an unbound report and subreports?
Click to expand...

Create a new Report, but don't select any table or query - just a
blank report. You can put any page headers, labels, etc. you like on
it.

Use the Subform/Subreport tool in the toolbox to put two Subreports
onto the main report; these can be pre-built reports, one for each
query, or the wizard will create new reports if you prefer.
 
Back
Top