• i've put more than a few posts on the board here on SSC, so I've helped an aweful lot of people.

    ;

    the best way to learn is to try. if you posted a query that wasn't working, but showed effort, we could help you learn.

    I'm really afraid you'll just take the solutions here, hand them in, but not understand them;

    when the next question comes that is similar, you'll be stuck, because you didn't get a handle on hte original.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!