Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Columns to Rows

Posted on 2015-02-12
13
Medium Priority
?
110 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
12 Comments
 
LVL 59
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 59
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
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: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 59
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 52

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 52

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 52

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
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 …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

571 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