Thanks everyone for the replies. I eventually figured out my problem. It took me about 4 hours of trial and error, but I got it to work. Also, Pbaldy, you pointed me in the right direction, but I couldn't quite wrap my mind around the code you referenced. I'm still pretty green when it comes to...
Thank you for the info.
However, I was able to output my Company names only. I wasn't able to break after each list change.
My output looks like this now MC, SFK, SM, TK, ICC, UB
I still need it to break and start a new row when List Name changes.
Hello everyone,
I hope someone can help me figure out a problem I'm stuck on. I would like to output column data into rows. I'm using MS Access 2000.
My current data set looks like this
testTable
List Name | Company
List 60 | MC
List 60 | SFK
List 60 | SM...