Hi Team, I have been trying to solve this. I have 2 Tables
Table 1: Master Database
Table 2: Targets Vs Actuals
I need to get the results in the "Actuals" field in Table 2 based on Year and status (as Completed) from the Master Database (Table 1). I have tried using queries, but I'm unable. Can any please help me solve this?
Note: There is no relation between these two tables.
Table 1: Master Database
Date | Function | Savings | Status of Project |
---|---|---|---|
01/01/2019 | ABC | 1000 | Completed |
01/01/2019 | BCD | 900 | On-Going |
01/01/2020 | ABCD | 1500 | Completed |
01/01/2021 | BCGA | 1500 | Completed |
01/01/2021 | HCFD | 1000 | Completed |
Table 2: Targets Vs Actuals
Years | Targets | Actuals |
---|---|---|
2019 | 500 | Need help here!! (1000) |
2020 | 700 | Need help here!! (1500) |
2021 | 1000 | Need help here!! (2500) |
I need to get the results in the "Actuals" field in Table 2 based on Year and status (as Completed) from the Master Database (Table 1). I have tried using queries, but I'm unable. Can any please help me solve this?
Note: There is no relation between these two tables.