"Roger Carlson" wrote in message
...
This would be better done in a report.

I assume that means it cannot be done in a single SQL statement but could be
done in some custom code or (better yet) crystal reports? Do you have any
favorite low $ cost alterantives (open source maybe) to purchasing crystal
reports? I suspect I would get quite a few hits if I google searched.

Thanks,
Siegfried