Solved

Consolidate Columns with Entries into 1 Field

Posted on 2013-01-22
7
190 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
  • 4
  • 3
7 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
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 119

Expert Comment

by:Rey Obrero
ID: 38807514
i might look into this later..
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

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

Accepted Solution

by:
Rey Obrero 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

911 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now