FrymanSMU
01-04-2010, 10:05 AM
So I found a solution from OBP that is usefule but I am trying to go the other directions and have a larger population I am working with. I am thinking about creating temp ADO queries in VBA and looping through them for each record but wanted to see if anyone had a more efficient way of doing this.
My end goal is to have a Record table that is unique by RecordID and include all risk codes for each record.
Source Data:
RecordID RiskCode Number
101 11 20
101 12 40
101 13 20
102 11 20
103 12 40
103 13 30
etc.....
End Goal
RecordID RiskCode11 RiskCode12 RiskCode13
101 20 40 20
102 20
103 40 30
Any help is appreciated and thank you for reading my post.
Happy New Years!
My end goal is to have a Record table that is unique by RecordID and include all risk codes for each record.
Source Data:
RecordID RiskCode Number
101 11 20
101 12 40
101 13 20
102 11 20
103 12 40
103 13 30
etc.....
End Goal
RecordID RiskCode11 RiskCode12 RiskCode13
101 20 40 20
102 20
103 40 30
Any help is appreciated and thank you for reading my post.
Happy New Years!