Showing data Horizontally instead of Vertically in a Query?

Copper Contributor

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 that does what you are looking for.