Results 1 to 5 of 5
Jul 16, 2012, 00:38 #1
- Join Date
- Feb 2005
- from Madrid to Heaven
- 200 Post(s)
- 1 Thread(s)
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:
jobPosition WorkerName Salesman Andrew Smith Manager Susan Roberts Director James Stwart
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.