Kind of a CrossTab but not?

[ebrooks54]

I just can't visualize how to do this one. Any help would be appreciated.

Table looks like this:

Acct / Rep ID
001 / A1
001 / A2
002 / A1
002 / A2
002 / A3

Output Table needs to be this:
Acct / Rep1 / Rep2 / Rep 3
001 / A1 / A2
002 / A1 / A2 / A3


Thanks

 

[MD5150]

You need three fields to create a cross-tab. A row heading, a column heading, and a value. Create a third field to store the rep number, then build a cross tab.

Something like:

Acct RepNbr Rep ID
001 Rep1 A1
001 Rep2 A2
002 Rep1 A1
002 Rep2 A2
002 Rep3 A3

I think this is the only way you can get the desired results you show.

Hope this helps.

Mike