Hi everybody,
I have 2 Table below:
Table 1:
Product No | Year | Month | Receiving Quantity |
A | 2015 | 6 | |
B | 2015 | 6 | |
C | 2015 | 6 |
Table 2:
Product No | Receiving Quantity | Year | Month |
A | 100 | 2015 | 6 |
B | 200 | 2015 | 6 |
C | 100 | 2015 | 6 |
A | 250 | 2015 | 6 |
B | 300 | 2015 | 5 |
C | 400 | 2015 | 5 |
A | 250 | 2015 | 5 |
B | 300 | 2015 | 5 |
C | 400 | 2015 | 5 |
All I want is In column Receiving Quantiy in Table 1, it will show the Total Receiving Quantity in Table 2 which match Product No, Year and Month.
The result should be like this:
Product No | Year | Month | Receiving Quantity |
A | 2015 | 6 | 350 |
B | 2015 | 6 | 200 |
C | 2015 | 6 | 100 |
I try a lot of formular but it does not work. Please help me in this case.
Thank you very much.
- Edited by SaigonCitizen 2 minutes ago