473,385 Members | 1,372 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Access ADP transpose multiple records into one

2
In an Access query, I am trying to do the following:

I have this:
Account # Issue Problem
-------------------------------------------------------------------
1 a Y
2 a N
2 h Y
2 w Y
3 d N
3 g N
4 c Y
5 c Y

I would like to get this (unique by acct#, and set # of additional columns):

Account # Issue1 Problem1 Issue2 Problem2 Issue3 Problem3
------------------------------------------------------------------------------------------------------------
1 a Y
2 a N h Y w Y
3 d N g N
4 c Y
5 c Y

Any help is greatly appreciated!
May 24 '07 #1
5 1972
MMcCarthy
14,534 Expert Mod 8TB
You have posted your question in the Articles section. I am moving it to the Access forum

ADMIN
May 24 '07 #2
hummer
2
I am reposting this to make more sense...

Access ADP transpose multiple records into one
--------------------------------------------------------------------------------

In an Access query, I am trying to do the following:

I have this:
Account # | Issue | Problem
-------------------------------------------------------------------
1 | a | Y
2 | a | N
2 | h | Y
2 | w | Y
3 | d | N
3 | g | N
4 | c | Y
5 | c | Y

I would like to get this (unique by acct#, and set # of additional columns):

Account # | Issue1 | Problem1 | Issue2 | Problem2 | Issue3 | Problem3
------------------------------------------------------------------------------------------------------------
1 | a | Y
2 | a | N | h | Y | w | Y
3 | d | N | g | N
4 | c | Y
5 | c | Y

Any help is greatly appreciated!
May 24 '07 #3
NeoPa
32,556 Expert Mod 16PB
Someone may be able to figure out a way to use Cross-Tab queries to answer your question exactly, but short of that, try :
(Listing Items Within GROUP BY Set)
May 24 '07 #4
NeoPa
32,556 Expert Mod 16PB
Your second post may well explain the situation better, but that should be done in the original thread so that it's possible for anyone to see what's already been posted and where you're at.
I've merged the two threads together.

Please let us know how you get on with the latest suggestion.
May 25 '07 #5
MMcCarthy
14,534 Expert Mod 8TB
You can't use a crosstab to return more than one column or one value per column.

Mary
May 25 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: WalterR | last post by:
This is my first time here, so there may be earlier relevant threads of which I am unaware. Though my experience with DB2 is not extensive, such as it is was under OS/390 or equ. My main...
5
by: jsudo | last post by:
I have a Access database with a large amount of records (close to 500,000) that I would like to export to Excel. I found out that Excel has the capability of of about 65,000 rows so I know I...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
35
by: deko | last post by:
Do I get more scalability if I split my database? The way I calculate things now, I'll be lucky to get 100,000 records in my Access 2003 mdb. Here some math: Max mdb/mde size = 2000 x 1024 =...
3
by: krygsma | last post by:
So, I need to figure out how to do what I want to do with Access. I have many questions with mutually exclusive options, each option has a value, never=0, few times=1...ect.. (then when questions...
13
by: Arno R | last post by:
Hi all, I will have to handle a lot of really 'nice' data in a LOT of Excel sheets. It is all about music files (Billboard top 100) I am afraid there really is a sheet for every year ... (Don't...
8
by: Leszek Gruszka | last post by:
I wrote code, that fill TableA with records by executenonquery. But i want to have second TableB, that will be transposed TableA. My code: Public Sub SQL_Wpis() Dim sSQL As String sSQL =...
2
by: SKarnis | last post by:
We are trying to rebuild a current Access 2002 (XP) mdb program to VB.NET with a SQL database - we are having problems with a suitable combobox. There are many threads discussing multiple column...
9
Boxcar74
by: Boxcar74 | last post by:
I think this is a little crazy but I supposed to figure out how to get the body of an email message (Outlook) into an Access DB table, with little to no effort :) Here is the deal I receive email...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.