SLQ Query... Values seens as column names
I need to do a query which I suspect it is not that difficult but obvioulsy I'm not searching for the right terms because I can't find the information anywhere in the world.
I'm using Access (because that's what I've been asked to) and I have a table that with four fields. I need to select two of those and show the values of one of them as the name of the column.
Let me give you an example. These fields have the following structure:
The output I need is
Salesman Andrew Smith
Manager Susan Roberts
Director James Stwart
Any thoughts? I would have thought that a TRANSFORM would do... except that you need to use aggregate functions and a file header (which I don't want)
Salesman Manager Director
Andrew Smith Susan Roberts James Stwart
Thansk in advance.
edit: It may be good to add that this query will be used to combine this table with a second table which has more information.
One of the fields in this table I've shown is a foreign key. If I do a regular inner join, I would get three files for every record of that table... something that I dont' want.