Transpose Vertical text values to Horizontal

[HickoryII]

I have a Volunteer Database that has teams. There is only one team leader but some of the teams have two or three assistants. Currently I have a query that lists all the assistants for each team vertically.
I've attached a picture of the query I'm using.
What I want to do is list the Assistants horizontally under headings like Assistant 1; Assistant 2; and Assistant 3 for each team on one line.
Can someone tell me how to do this? Your help would be much appreciated!
Hickory II

 

[CJ_London]

You could use a crosstab query - providing you have a field which says 'assistant1' or 'assistant2' etc, otherwise Access does no know which column to put an assistant in.

If such a field exists, this is the column heading, the value heading would be the assistant name and set to 'first' whilst all the other columns would be row headings

 

[HickoryII]

Right now they are all listed as simply Assistant in the "Description" column. I'm kind of new to this so if you could explain a little more fully exactly how I go about setting this up I'd be very grateful. Thanks

 

[gblack]

Yeah, so basically you have to have a column to your table... maybe call it: [Job level].

Once you add that caolumn to your table, you will then have to go through and tag each person with a designation (e.g. "Team Leader" or "Assistant 1", "Assistant 2" etc... etc..)

Once you have everyone designated, you can then make a crosstab query using the Team designation as your record value, the [Job Level] as your column value... and the names of the people as the crosstab values.

GL

 

[Galaxiom]

Take a look at this thread which shows how to do what you want in a Crosstab without having to generate a list of positions or have them in a table.

http://www.access-programmers.co.uk/forums/showthread.php?t=221397

 

[HickoryII]

Thanks for all the input from everyone. I'm sure I'll be able to achieve the desired results with the references so helpfully provided; especially the one offered by Galaxiom. This is a wonderful forum for solving Access problems.