|
Posted by franzey on 03/29/07 16:43
This is how the data is organized:
vID Answer
12 Satisfied
12 Marketing
12 Yes
15 Dissatisfied
15 Technology
15 No
32 Strongly Dissatisfied
32 Marketing
32 Yes
What I need to do is pull a recordset which each vID is a single row
and each of the answers is a different field in the row so it looks
something like this
vID Answer1 Answer2 Answer3
12 Saitsfied Marketing Yes
etc...
I can't quite get my mind wrapped around this one.
Navigation:
[Reply to this message]
|