Gazereth,

I read your edit. Thanks.

Right now, it seems, if I use the union, I will be able to append the Total unique leads at the bottom of the report. In 'real life' I also have division, region, and date parameters. When I filter with them, it manipulates the first query results very well, and then just appends the Totals of the second union at the bottom resulting in disjointed way.

I will need the report to respond dynamically to provide total unique leads, not just for the whole set but by each property if the selected filter happens to be by property.

Is there a way to apply one set of filters to two seperate queries?