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...
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.
