By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,820 Members | 957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,820 IT Pros & Developers. It's quick & easy.

Access ADP transpose multiple records into one

P: 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
Share this Question
Share on Google+
5 Replies

MMcCarthy
Expert Mod 10K+
P: 14,534
You have posted your question in the Articles section. I am moving it to the Access forum

ADMIN
May 24 '07 #2

P: 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
Expert Mod 15k+
P: 31,770
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
Expert Mod 15k+
P: 31,770
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
Expert Mod 10K+
P: 14,534
You can't use a crosstab to return more than one column or one value per column.

Mary
May 25 '07 #6

Post your reply

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