• Here are some hints:

    a) Don't start a project the night before it's due if the subject is something you're struggling with

    b) Please note that this is a SQL Server forum and not ACCESS (even though the very basic SQL code would be close to be identical). So, even if we 'd provide a SQL solution, you might not be able to use it.

    c) To provide nothing but a few links to your homework (?) doesn't really show any effort on your side. That usually reduces the number of people willing to reply. Dramatically.

    There's not much more to say from my side...



    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]