Solved

Columns to Rows

Posted on 2015-02-12
13
91 Views
Last Modified: 2016-02-10
This is what I have and what I needDB.pngdb1.png
0
Comment
Question by:Joe Vaughan
  • 3
  • 3
  • 3
  • +2
13 Comments
 
LVL 57
ID: 40606058
See:

"Domain Aggregate" for Concatenating Values by Group in Microsoft Access
http://www.experts-exchange.com/Database/MS_Access/A_2380-Domain-Aggregate-for-Concatenating-Values-by-Group-in-Microsoft-Access.html

 Holler if you have any questions.

Jim.
0
 

Author Comment

by:Joe Vaughan
ID: 40606102
Hey Jim, I can research this stuff.  I need the specifics in this solution...thus my subscription.  Like saying..."Oh the answers on google!"  jk   So provide me the solution per my example and I will gladly except my friend!
0
 
LVL 57
ID: 40606147
Tim,

 Not sure what your expecting...and I don't know your level of experience.

 The answer to your question is cut and dry and I pointed you directly to a solution, which is largely self-explanatory.    If you look through the article, you'll see that you have to drop the code into a module, then make a call.

 If you have questions on doing that, then as I said, just ask.

Jim.
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:Joe Vaughan
ID: 40606249
You sent me a link with several things to read.  I guess this site doesn't provide the solution but indirectly provides the solution.  For example; 1+2=?.  Do you send a link or answer it with the number 3.  That's all.  Sure experience accounts for a lot but depending on your role within your department who'll determine if a person is asking a question to see how it can happen, or assisting others in a  solution for potential input in a meeting etc....this site way back in the, I could send my database to a person and it would be fixed in minutes.  Now it appears to be a link referral site.  I get it...Just don't approve of giving points for being directed to the a variety of solutions verses providing the answer.
0
 
LVL 57
ID: 40606594
Tim,

<<You sent me a link with several things to read.  I guess this site doesn't provide the solution but indirectly provides the solution. >>

 So would you like me to type out everything that is in the article here?   You asked a question that has a very specific answer and that article is spot on in terms of solving it.  It even includes a "how to implement" section.

  If your question was not so cut and dry I certainly would have taken the time to answer it here.   But I'm not going to spend an hour on something when I can point to a very well thought out and articulated solution by one of the other Expert's here .    No other Expert is going to bother either.

<<this site way back in the, I could send my database to a person and it would be fixed in minutes.>>

 Sorry, but this site has never been a "rent a coder site" (and I have been here answering questions since 1999, so I would know).

Understand that your subscription here entitles you to nothing more than the ability to search and ask questions, and use other site features.

If you want it done for you and not have to do the work, then hire someone.   Many of the Experts have enabled the "Hire Me" feature in their profiles.

If you want to do it, great.  I am perfectly willing to help you work your way through this, but I am not a mind reader and have no idea of your level of knowledge.

I've gotten everything from "That was great, all I needed.  Thanks." to "well I have  bunch of questions because I've never done any VBA before"

So if you have questions about what's in the article, then ask away.   If not, then you have a solution.

Jim.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40606621
The issue is that your desired output does not lend itself to crosstabs directly.
You have a need to add "columns" dynamically

Lets see if an SQL Expert can get you sorted.
0
 

Author Comment

by:Joe Vaughan
ID: 40606645
Hey Jim, don't be offended.  Your solution isn't preferred.  

Have a great day!
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40606773
Ouch, this was not easy. Still, two queries and a lot of Dxx will do:TCross demo/gustav
TCross.accdb
0
 

Expert Comment

by:bodywise
ID: 40723823
And herein the problem with Experts Exchange.    "Well you sort of do this."  Rather than a line by line example.   We come here after looking for all the easy solutions.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40724425
> "Well you sort of do this."  

No. It did it.

> We come here after looking for all the easy solutions.

Sorry about that, but you don't count for "we", and not all questions allow for an "easy" solution.
The fun part is to solve the difficult matters.

/gustav
0
 

Expert Comment

by:bodywise
ID: 40724463
Savvy and experienced "experts" can reduce difficult problems to elegant solutions.   And it is not by a quick "here use this reference."   It is by meticulous example with requisite lines of code.  That is what "we" seek by coming to experts exchange.   I know the game.   Experts are rewarded  by quick and voluminous answers.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40724496
> It is by meticulous example with requisite lines of code.

OK. Then feel free to download the example database. That's what it is for. You may even find it elegant.

>  I know the game.   Experts are rewarded  by quick and voluminous answers.

I'm not sure you do. Experts are rewarded by the questioneers for satisfying answers. Of course, quick is good, but voluminous is in general not; people are too busy for that.

/gustav
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

860 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