I have a database that holds account teams and members

I want to create a report that looks like this

Accountteam ENGLAND
J.S. Bach              W.Mozart         R Schumann
L. van Beethoven

So depending on the number of members I get 3 on a line and then a next line

It must be easy, but sometimes you just don't see the light...

Frank-

A variation on MacGuyver perhaps?

You can layout the Names in three columns by adding a number 1, 2 or 3 to each Name and doing an ACROSS NUMBER...e.g.
DEFINE FILE DATA
NUMBER/I3 WITH NAME=IF NUMBER EQ 3 THEN 1 ELSE NUMBER +1;
ROW/I3=IF NUMBER EQ 1 THEN ROW+1 ELSE ROW;
END
TABLE FILE DATA
HEADING
"Accountteam England"
SUM NAME AS '' ACROSS NUMBER NOPRINT
BY ROW NOPRINT
END

Sometimes we think to complex.....

quote:

Accountteam ENGLAND
J.S. Bach W.Mozart R Schumann
L. van Beethoven

So, Frank, you're suggesting that England play 3 at the back on Wednesday's football [soccerball] game against Russia with Ludwig van Beethoven in the Midfield Holding Role?

John

some secret weapons....they were very good players, only Beethoven holds himself sometimes a bit deaf to all warnings