• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

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
0
Dare626
Asked:
Dare626
  • 4
  • 3
1 Solution
 
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
 
Rey Obrero (Capricorn1)Commented:
i might look into this later..
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Dare626Author Commented:
Thank you capricorn.
0
 
Rey Obrero (Capricorn1)Commented:
see this

the codes  that populate the table_result is at module
Sample-Data.mdb
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now