My report was working perfectly until I needed to add in another table. The first table has one record for each phase code per month like below:
Mth Phase Amt
5/1/2016 1604. 61,056.60
6/1/2016 1604. 0.00
7/1/2016 1604. 0.00
The table I am trying to add has multiple lines for each month like below:
Mth Phase Amt
5/1/2016 1604. 26,292.30
5/1/2016 1604. 16,210.80
5/1/2016 1604. 18,553.50
When I link the 2 tables together my first table does this:
Mth Phase Amt
5/1/2016 1604. 61,056.60
5/1/2016 1604. 61,056.60
5/1/2016 1604. 61,056.60
6/1/2016 1604. 0.00
7/1/2016 1604. 0.00
It repeats the month 5/1/2016 3 times because the 2nd table has 3 rows of data for 5/1/2016 for that phase. Is there a way around this? Here is my current link:
Table 1: Table:2
Mth UIMth
JCCo JCCO
Job Job
PhaseGroup Phase Group
Phase Phase
Cost Type JCCType
I am using a left outer join.
Thanks!
Mth Phase Amt
5/1/2016 1604. 61,056.60
6/1/2016 1604. 0.00
7/1/2016 1604. 0.00
The table I am trying to add has multiple lines for each month like below:
Mth Phase Amt
5/1/2016 1604. 26,292.30
5/1/2016 1604. 16,210.80
5/1/2016 1604. 18,553.50
When I link the 2 tables together my first table does this:
Mth Phase Amt
5/1/2016 1604. 61,056.60
5/1/2016 1604. 61,056.60
5/1/2016 1604. 61,056.60
6/1/2016 1604. 0.00
7/1/2016 1604. 0.00
It repeats the month 5/1/2016 3 times because the 2nd table has 3 rows of data for 5/1/2016 for that phase. Is there a way around this? Here is my current link:
Table 1: Table:2
Mth UIMth
JCCo JCCO
Job Job
PhaseGroup Phase Group
Phase Phase
Cost Type JCCType
I am using a left outer join.
Thanks!