Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Consolidate Columns with Entries into 1 Field

Posted on 2013-01-22
7
Medium Priority
?
198 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
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 

Author Comment

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

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

722 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