Barbara,
Would you believe i did the opposite and it worked? You gave me the hint. Instead of going nuts on multiple SQl - selects, I used one and comparing the variables it seemed to work. It was the hint on the EMPTY('') variables giving a general search for that filter. This time it recognized the global variables.
Perry
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.