Hi all
I have 2 identical tables with different data.
They have both been imported from excel as I couldn’t do this in excel.
Table 1 has data from Dec Table 2 has data from Jan
Fields are: EENo, Code, Date (Fixed either Dec or Jan), Value
Table 1 will have Decembers Value and Table 2 will have Januarys Value. Table 2 may also have some NEW EEno
What I would like to do is compare both tables and take the Value from each and take one away from the other.
Example: Table 1 Value is 1000 for EE1 and Table 2 Value is 500 for EE1, so I would like maybe a 3rd table which will have the difference i.e. EE1 Value = 500
Is this possible?
Thanks
I have 2 identical tables with different data.
They have both been imported from excel as I couldn’t do this in excel.
Table 1 has data from Dec Table 2 has data from Jan
Fields are: EENo, Code, Date (Fixed either Dec or Jan), Value
Table 1 will have Decembers Value and Table 2 will have Januarys Value. Table 2 may also have some NEW EEno
What I would like to do is compare both tables and take the Value from each and take one away from the other.
Example: Table 1 Value is 1000 for EE1 and Table 2 Value is 500 for EE1, so I would like maybe a 3rd table which will have the difference i.e. EE1 Value = 500
Is this possible?
Thanks