Ok.. I've been playing with the DB and have been able to parse out the additional column (BUC_ASC) into two columns (AltSub_Num & AltSub_Name). I added the code for the column input and column outputs as I did before and changed "recordnumber = 1 to recordnumber = 2". When I ran it, I started seeing data in the two output columns. However, I get an error "Run-time error '5': Invalid procedure call or agrument".
When I took a look at the data and moused over the code (to get the popup), I noticed that it seems to be failing at the point where it runs into a null value. This will be an issue since there will definitly be null values in this column. In other words, we will always have something in the BUC_MC field and (in theory) something in the Plan_Name field. But, the BUC_ASC field may or may not have data in it.
Oh! also, there is data in the column BUC_ASC that has a ":" in place of the "_". It may be "2103:AC2.0:Non-Standard Confirmation Process" and should be "2103_AC2.0:Non-Standard Confirmation Process".
Chris