Consolidate Columns with Entries into 1 Field

Hi Expert's

I have an access table that has about 200 columns horizontal for every member, on each is populated with a 'YES' is they fell under that group, i would like consolidate this column headings into 1 table with the member number in 1 column and the other with all the corresponding codes for that member, i cant figure out a way of doing this without using some sort of VBA code. Id really appreciate your help on this...I've illustrated my problem below and the access database has sample Result_Table_Sample table so you can see exactly what i mean. Thanks again experts.
Sample-Data.mdb
Problem-Visulized.vsd
Dare626Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
see this

the codes  that populate the table_result is at module
Sample-Data.mdb
0
 
Rey Obrero (Capricorn1)Commented:
you definitely need VBA codes and recordsets to accomplish this
0
 
Dare626Author Commented:
Thank you kindly capricorn, however i lack this skill at the momment. I am learning tho but i wouldnt be able to figure it out.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Rey Obrero (Capricorn1)Commented:
i might look into this later..
0
 
Dare626Author Commented:
Thank you capricorn.
0
 
Dare626Author Commented:
Thank you Capricorn ill take a look at it in a few, i appreciate your time.
0
 
Dare626Author Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for Dare626's comment #a38807742

for the following reason:

Your a lifesaver Capriocorn thanks so much!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.