Situation:
Single database field, we'll call it: CONTACT.CLASS This field goes in to the Report to display values such as A, B, C, X, Y, Z. What I would like to do is seperate into two columns A,B,C and X,Y,Z. See below for an example
A,B,C X,Y,Z
------------------
A X
B Z
B Y
C X
etc. etc.
How can I do this? I've tried grouping and formating and nothing seems to let me seperate this data out from the same field...any suggestions??? Thanks in advance!!!
Single database field, we'll call it: CONTACT.CLASS This field goes in to the Report to display values such as A, B, C, X, Y, Z. What I would like to do is seperate into two columns A,B,C and X,Y,Z. See below for an example
A,B,C X,Y,Z
------------------
A X
B Z
B Y
C X
etc. etc.
How can I do this? I've tried grouping and formating and nothing seems to let me seperate this data out from the same field...any suggestions??? Thanks in advance!!!