>>Michelle
>
>I didn't look closely your city filter :)
>
>tcCity = iif(!empty(tcCity),'city = '+tcCity, 'city = ""')
>
>Would work (unless ANSI is on)?
>Cetin


Thanks, but I don't think you're understanding my question. I'm not having a problem with the filters leading up to the main select. My problem is that once the cursors are filtered, my main join can't tell the difference between a job that has no addresses at all and a job that had no addresses that matched the filter.

I think the idea you sparked might do it, but I need to reboot before I try. My last attempt accidentally did a Cartesian join on rather large tables and my system is running rather slowly now. :)

Thanks,

Michelle