Thanks for the replys!
But I think I'm a little lost - I just want this to happen with the on report load. As far as changing the entire query, I have over 100 tables all union - are you saying that i need to add that line to every instance?
I tried to just change the control source to what...