I am having a problem with multiple lines (each with one value) showing up when I try to use Across. The table (master file) has three fields SUBSCRIBERID, QUESTION, ANSWER and is set up as:

SUBSCRIBERID QUESTION ANSWER
111 Question1 Answer1
111 Question2 Answer2
111 Question3 Answer3
222 Question1 Answer1
222 Question2 Answer2

What I am getting when I use BY SUBSCRIBERID and ACROSS QUESTION is:

SUBSCRIBERID Question1 Question2 Question3
111 Answer1 . .
111 . Answer2 .
111 . . Answer3
222 Answer1 . .
222 . Answer2 .
222 . . Answer3


What I am hoping to see is:

SUBSCRIBERID Question1 Question2 Question3
111 Answer1 Answer2 Answer3
222 Answer1 Answer2 Answer3

Any help would be greatly appreciated.

Thanks,

Rob

Use SUM instead of PRINT. I know it is not intuitive. But trust me, it should take care of your problem.

That worked perfectly. Thank you for the help, Ginny.

Rob