Solved

MS access changes vertical column into rows

Posted on 2014-03-18
1
329 Views
Last Modified: 2014-03-18
I have a query where the output look like example 1, but i need it to look like example two.  I am using MS Access 2007.
Example 1:
Diamonds       page 17
Diamonds      page 3
Diamonds       page 5
Bracelets      page 15
Bracelets      page 10
Bracelets       page 4

Example 2:

Diamonds page 17, page 3, page 5
Bracelets page 5, page 10, page 4

I tried a cross tab query but it didn’t work
0
Comment
Question by:deefel
1 Comment
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 245 total points
ID: 39938241
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

947 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

21 Experts available now in Live!

Get 1:1 Help Now