?
Solved

Columns to Rows

Posted on 2015-02-12
13
Medium Priority
?
102 Views
Last Modified: 2016-02-10
This is what I have and what I needDB.pngdb1.png
0
Comment
Question by:Joe Vaughan
[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
  • 3
  • 3
  • 3
  • +2
13 Comments
 
LVL 58
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 58
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
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 

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 58
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 51

Accepted Solution

by:
Gustav Brock earned 2000 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 51

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 51

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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.
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 …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Suggested Courses

764 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