• Meaning that you want to be able to pick all states? (by making no selection) if so, then create your statement dynamically and only drop in the state if selected. If that's not what you want, please clarify.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."