Casie Renegar
asked on
2 queries into 1 Report
I have 2 queries that are giving me different data from the same source. They have no values in common. I need to put both of these queries into just 1 report. Any suggestions on a simple way to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
plae the two subreports in the detail section of the main report
ASKER
How do you format the report then? One of my queries I need to display the information across the bottom of the page. I am sorry, I have only been working with Access to build stuff like this for a few weeks.
Then perhaps you should take a step back and explain:
1. Why you are using two queries instead of one (if you need "one" report)
2. The difference between the two queries
3. How the two queries would be linked to produce the report?
...linked on a common field?
...Hierarchically?
...Union (one dataset stacked on top top another)...
...or some other configuration...
it is rare to have a report based on two queries (with both queries based on the same datasource)
So you will have to explain this non-standard design...
In other words, state clearly what you ultimately need...
...Not how you want us to solve the question:
For example:
"I have a datasource that displays____________"
"I need a report that displays__________________
Then provide a real world example....
JeffCoachman
1. Why you are using two queries instead of one (if you need "one" report)
2. The difference between the two queries
3. How the two queries would be linked to produce the report?
...linked on a common field?
...Hierarchically?
...Union (one dataset stacked on top top another)...
...or some other configuration...
it is rare to have a report based on two queries (with both queries based on the same datasource)
So you will have to explain this non-standard design...
In other words, state clearly what you ultimately need...
...Not how you want us to solve the question:
For example:
"I have a datasource that displays____________"
"I need a report that displays__________________
Then provide a real world example....
JeffCoachman
ASKER
I have a data source that displays various solvent measurements for different pieces of equipment during various months. I need the sum of those measurements based on solvents, dates and equipment. The only way I have been able to get my queries to display the information the way that I need it is to have two difference ones. One query is for dates and solvents. The second is for the equipment used in that time. If I try and run them as one query, I get multiple date enteries for the month, I need the report to just have one entry per month.
The way that I need the report to display the information is: the equipment used during that time frame down at the bottom of the page. And the dates and solvents at the top.
The way that I need the report to display the information is: the equipment used during that time frame down at the bottom of the page. And the dates and solvents at the top.
< I get multiple date enteries for the month, I need the report to just have one entry per month. >
have you tried using a Total query?
have you tried using a Total query?
ASKER
Yes I have. I am using a Total Query on the dates now. That is why I had to remove the equipment from the query.
can you upload a copy of the db?
also, create mockup of the report using excel and upload it too.
also, create mockup of the report using excel and upload it too.
ASKER