Solved

Consolidate Columns with Entries into 1 Field

Posted on 2013-01-22
7
197 Views
Last Modified: 2013-01-23
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
Comment
Question by:Dare626
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38807485
you definitely need VBA codes and recordsets to accomplish this
0
 

Author Comment

by:Dare626
ID: 38807492
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38807514
i might look into this later..
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Dare626
ID: 38807742
Thank you capricorn.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 38807772
see this

the codes  that populate the table_result is at module
Sample-Data.mdb
0
 

Author Comment

by:Dare626
ID: 38810883
Thank you Capricorn ill take a look at it in a few, i appreciate your time.
0
 

Author Comment

by:Dare626
ID: 38812790
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question