That worked with one minor adjustment.

In the expression I had to put DATEADD("d", -30, @date)

I had already explicitly set the data type in query 2 "Declare @var1 char(2)

".

Here is want I ended up doing. I created a text box and put the Iif statement...

Post the queries that you are using.

Then it sounds like you need to create a dynamic query. That is how I get all as the default. Here is a link to a walk througt to create...

I have had the same problem before. I over came it by creating a dataset that would only return the default value that I needed and used that query to set the...

Thanks for all your help directing me to the right places. And I thought there was a trick to acomplish this.

Yes that is what I want to have happen. Could you give me an example?

You can't do a data driven report unless you have Enterprise addition.

Ya I know I though this was the best place, not the programming forum. Thanks!

Worked pefect, Thanks!

Yes that was much faster, but the problem I have is that not all the rcitem.freceiver are in rcinsp. So the way you wrote the query does include the null...

Thanks for your reply!

How would I do the the calculation in a subquery?

Thanks for your reply.

I tried as you suggested and it still returned to many results and over inflated the total.

It would be so much simpler if I didn't need info...

Searched through the post and found an answer to my own question. Should have done that first. Thanks!