• I just can repeat what I stated before:

    Please read and follow the advice given in the first link in my signature and post ready to use sample data together with your expected result and what you've tried so far.

    Based on the vague description there's little we can do....

    Did you even bother to read that article? :ermm:



    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]