• i really like the answers that point to a link with letmegooglethatforyou.com...i really think it makes people think twice.

    so yeah, our answers might be a little arrogant when we do that...but hey.

    really, i think there are only like 6 questions that keep getting repeated over 90 percent of the posts, and the other 10% are the ones that we enjoy.

    The most common? i think are:

    1. not understanding how to get a datetime or dateadd value in a query?

    2. pivot table/crosstab/rows-to-columns?

    3. how do i fill in non-existant data with a Tally Table?

    4. comma delimit a bunch of fields or columns into a single field?

    5. how do i find out who deleted/updated something?

    6. what's the answer to my homework?

    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!