General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access Query
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