I have a query that combines the results of two other queries:
One query runs data for the current month.
One query runs data for the past month.
The purpose is to obtain two columns of values associated with each department used in each month.
Department Current Month Past Month
If the same department is used in both months, the values are side by side in the same recordset. If only one month has a value, the value in the other month will be a zero.
The two original queries contain the same fields.
One of the fields is ?department? and one other is ?dollars?.
There are 200 departments ? BUT ? not all departments are used each period, NOR, are the same departments always used each period. The report is to show only the departments where there is activity.
Scenario 1: query 1 and query 2 have the same number and Department_ID in each. ? No problem with this.
My problem is how to deal with the next two scenarios.
Scenario 2: query 1 has more departments than query 2
Scenario 3: query 2 has more department than query 1
If I set the join relationship for Scenario 2, then Scenario 3 returns skewed data (and vice versa).
Is there any way of resolving this join problem?
Thanks, Rich