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