Instead of trying to describe the issue you're struggling with just verbally, it would be more helpful if you could post some sample data so we have something to test against.
Lutz
A pessimist is an optimist with experience. How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]