Display vertical info horizontally

[dpill]

Hey all, quick question:



Is there a way to query data from a column and show it across a row?

Example:

I want to show the date stamps per meeting type for each client

Client Name	1st Meeting	2nd Meeting	3rd meeting
John Doe	3/17/16	3/18/16
Jane Doe	2/15/16

The blank cells would represent there not being info for that specific individual/type of meeting.

Here's how I have my database organized right now and this was my failed attempt at querying the data.






I'm just learning so be gentle!

[orange]

You can try this function from Allen Browne.

More info here http://accessdatabasetutorial.com/20...-in-ms-access/

[alansidman]

This video should help to show you a way

http://www.datapigtechnologies.com/f.../crosstab.html

[dpill]

First - I appreciate the quick responses.

It doesn't look like you can get around the value portion of a crosstab query... which seems to be the snag on this. Ideally, I just want the column header to be the meeting type and if there is a date for that specific client under that specific meeting type to have the date input under that specific column. Maybe there's a better way to organize my data to make this process more efficient? I watched the video which was sort of helpful and I looked at the function for concatenation but in either case it didn't seem to have a solution for posting the date as mentioned above.

[alansidman]

Suggest you upload your database with sample data (confidential data dummied up). I am confident that with that someone here can provide you with a solution. No one wants to recreate your db and guess at your data types, etc. Therefore a sample representative db will be needed.