K
Kelvin Leong
I was wondering whether this can be done using a query. I don't want the
existing field to be split into more than 1 field. Just keep it as it is.
I have 2 tables: Case and CaseDet, and both are linked by CaseID. The
scenario is that 1 case has many case details. In the CaseDet table, there
are two other fields called CaseCo1 and CaseCo2.
If CaseCo1 = ABC, then value of CaseCo2 is displayed in Col1
If CaseCo1 = XYZ, then value of CaseCo2 is displayed in Col2
End of the day, I want to display the result in a report:
No | CaseID | Col1 | Col2
-------------------------------------
1 | 1000 | 100 | 200
2 | 1001 | 50 | 50
-------------------------------------
| 150 | 250
Do let me know whether such an idea is possible. Thank you very much.
Best regards,
Kelvin
existing field to be split into more than 1 field. Just keep it as it is.
I have 2 tables: Case and CaseDet, and both are linked by CaseID. The
scenario is that 1 case has many case details. In the CaseDet table, there
are two other fields called CaseCo1 and CaseCo2.
If CaseCo1 = ABC, then value of CaseCo2 is displayed in Col1
If CaseCo1 = XYZ, then value of CaseCo2 is displayed in Col2
End of the day, I want to display the result in a report:
No | CaseID | Col1 | Col2
-------------------------------------
1 | 1000 | 100 | 200
2 | 1001 | 50 | 50
-------------------------------------
| 150 | 250
Do let me know whether such an idea is possible. Thank you very much.
Best regards,
Kelvin