Unanswered: SOLVED: How Do I Combine Several Fields and put a > between each.
I'm having so much success with the help of people in this forum. It's amazing and I appreciate it so much. I have been learning Access at a rapid pace but with anything there's a curve so I have another 'newbie question'.
I have an empty Field named: category_name
I am trying to merge the data of six other fields into one, separating them with a > and no spaces.
Make believe that each of the HIERARCHY field names above have words in them. Say it's the word representing the number at the end of it. Like if it ends in 1, then the word would be One (in my dB they are sometimes more than one word separated by a comma and space). The result of the merged data would be.
I tried a few methods that aren't working. Is an update query not the right tool for this? Any suggestions?
Last edited by RBusiness; 01-30-12 at 16:06.
Reason: Solved - noting in title