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

Moving Column information into a Row

P: 2
Hi,
I am working with an Access report and I am trying to move Data that is listed as a column into a row format.

Ex: Existing Column

Name: Organ:
Joe Doe Heart
Joe Doe Liver
Joe Doe R. Lung
Joe Doe L. Kidney
Joe Doe Pancreas


What I want:

Joe Doe: Heart Liver R. Lung L. Kidney Pancreas

I have written an If statement to show this on the report but the numbers are scatterd down the page and aren't directly across from the name of the person

Can anyone help? I just need to be pointed in the right direction.

Thank you!
Larry
Aug 6 '07 #1
Share this Question
Share on Google+
2 Replies


RedSon
Expert 5K+
P: 5,000
These access folks are very nice. Only believe half of what they tell you.
Aug 6 '07 #2

P: 2
Thanks but I got that one figured out...I had to use a cross tab query.
Aug 7 '07 #3

Post your reply

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