Forum Discussion
Showing data Horizontally instead of Vertically in a Query?
I'm relatively new to Access, but decently familiar with Excel. I've been attempting to have data from multiple tables show up together. I've figured out the query needed to an extent. However I'm trying to have the data show up Horizontally.
Example - a person plants things in their yard. A person plants multiple areas (front, side, back) with multiple items (bushes, trees, flowers, etc)
Instead of Access showing, each in their own row (Vertically😞
Person - Front - Bushes
Person - Side - Trees
Person - Side - Flowers
Person - Back - Bushes
Person - Back - Flowers
I'd like Access to show each Area of the Yard in its own Row (Horizontally😞
Person - Front - Shrubs
Person - Side - Trees - Flowers
Person - Back - Bushes - Flowers
Is this even possible?
3 Replies
cutesmaj What you need is a Crosstab query:
George_Hepworth Thank you I just tried a cross tab query per your suggestion. Which is a nice feature, unfortunately it is giving me counts of the data points instead of the actual list. Is there a selection that I need to choose instead? I really appreciate your suggestion. And it will help me in other areas, but sadly not this one.
cutesmaj Unfortunately Access does not have any built in functions to list out multiple values like you want to do. You will need to create a custom function. There is a good link to one at http://allenbrowne.com/func-concat.html that does what you are looking for.
