Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LavaNewt
Starting Member
1 Post |
 Posted - 2004-08-20 : 14:54:07
|
font=Arial][/font=Arial] I have a table in an Access 2000 database: [SAP_Survey_Answers] that contains FieldNames: CO_ID, ES_ID, PKey, QFieldName, QAnswer. The *_ID are ID#, QFieldName lists the questions in a survey, & QAnswer corresponds to the QFieldName and gives the answer given by the customer. Here's the dilema: I need to create a new table with CO_ID, ES_ID as Field Names BUT I also need each question as a new field name. How can this be done? Query? SQL statement? I've been racking my brain on this one. Any help would be greatly appreciated!--Basically we're an outbound call center and the "Client" gives us a "script" that our Reps use to question customers. The questions and answers are automatically entered into an Access database via the "script". The "Client" then wants the info back in a table as stated above. So if anyone can come up with anything to help me out it would be AWESOME!!! |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-08-20 : 16:02:14
|
| Excel. they don't want the data in a relational DB format, so your best bet is to give them an Excel sheet. don't try to create tables w/ that structure.- Jeff |
 |
|
|
|
|
|
Create Table FieldName using Field value