Hi folks.
I am using CR10 against MS Access. I have 2 tables with Service Code and Volume. Some times the Service Codes are the same, most of the time, they aren't. All of the Service Codes are unique. For example,
Service Code 1 Volume Service Code 2 Volume
1001 100 1547 50
2500 250 2500 100
3333 75 9999 47
Here is my issue. I want to combine the 2 Service Code columns into 1. Where they match, I must add the volumes. Where they don't match, I just want to take the unique volume from that associated Service Code. I want my end result to look like this:
Service Code Volume
1001 100
1547 50
2500 350
3333 75
9999 47
Any ideas? Thanks.
Scott
I am using CR10 against MS Access. I have 2 tables with Service Code and Volume. Some times the Service Codes are the same, most of the time, they aren't. All of the Service Codes are unique. For example,
Service Code 1 Volume Service Code 2 Volume
1001 100 1547 50
2500 250 2500 100
3333 75 9999 47
Here is my issue. I want to combine the 2 Service Code columns into 1. Where they match, I must add the volumes. Where they don't match, I just want to take the unique volume from that associated Service Code. I want my end result to look like this:
Service Code Volume
1001 100
1547 50
2500 350
3333 75
9999 47
Any ideas? Thanks.
Scott