And here is a copy of the results

Name customer type Total
1100813 John a1 1
a2 1
a3 1
a4 1
a5 1

b1 2
b2 2
b3 2

c1 3
c2 3

d1 4
d2 4
d3 4
d4 4

1102312 Amy a1 1
a2 1
a3 1
a4 1
a5 1

b1 2
b2 2
b3 2

c1 3
c2 3

d1 4
d2 4
d3 4
d4 4

1102367 Todd a1 1
a2 1
a3 1
a4 1
a5 1

b1 2
b2 2
b3 2

c1 3
c2 3

d1 4
d2 4
d3 4
d4 4

I negelected to tell you to turn off column totals - Pivot Table, Table
Options...
This was all done in 2003 but you can do the same in 2007 or 2010.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"fzl2007" wrote:

On Mar 26, 11:07 am, dan dungan wrote:
Will a pivot table work for you?


No. It doesn't do exactly what I describe.
.