Thank you all....the scripter works perfect.

OK, did that, Thanks. Now I am getting the following error.

contains an error: Operator '>=' is not defined for type 'Decimal' and type 'Date'.

All figured out

Thanks...learning more every day! 🙂

Thanks for the effort! Works perfect!

Ok...to clarify,

Our DB has zip codes in a 'zip + 4 ' format. For example, a zip + 4 could return lots of variations for zip code 05732....

could be 05732-1111,05732-2222,05732-3333....

Thank you all....I figured it out

Hello,

please take a look at my statement....is this where I would make my changes, so that I don't have to choose all of the 5 parameters? Thanks!!

SELECT ...

OK...if I just want the date to return as 10/9/2009, how do I do that? I used the start date in one text box and the end date in another,...

Thanks...I am really new to this. How would I allow my statement to handle this?

What I am doing is

1.selecting the parameter

2. Selecting 'Allow Blank' Value

3. In Default Value...I selct 'Not Queried' then blank...

This is not working...what do you think I am missing?

Thx

Ok ...I am getting there..Made a couple of changes.

What I am actually trying to do is divide the number of wins by the total count of status. For some reson...

Thank you ALL so much.....

I have now learned something new. Again, I am all set with this topic. Thank you

Thats it....thanks! Is there a way to insert date picker controls in the report?

Thanks... what I would like to do is just add two inputs in the report that add a start date for the report and an end date. This would be...