Dude you freakin Rock! Thank you very much and I appreciate all the feedback and support from everyone here. Greatly appreciate!

I should have attached this image instead, as it shows the table without the LINE filter. Since we need to compare the LINES we will first need to group or...

Thanks for the feedback. Yes the most recent row in the change table reflects what the actual DUE_DATE is in the primary table. I tried the following CTE, but still...

Attached is an image of our table. The LINE_CHANGE_DOC_NO is an identity column and the PO number is the primary key on the table we are tracking.

Here I am...

I appreciate the feedback. I will move forward keeping them seperate.

Thanks!

That worked great. Much appreciated.

Thanks for all the replies on this. Much appreciated!

I would like to add it to the existing code. Is that possible?

Did you ever find a resolution to this? I am running the x86 adapter and I am only trying to pull in one field, but still no luck.

I figured this out. Changed up the dataset query and changed the parameter properties to allow blanks and multiple values. Thanks.

I got it to work using the following logic:

=IIF(a > 0, 200/IIF(a = 0, 1, a), 0)

Thanks for the help. Much appreciated.

I placed the logic in two new textbox expressions and they both returned the correct data. I am stumped as to why I am still getting the #Error. Thanks for...

I changed up the expression to test for zero at the beginning. The expression looks good and does not reflect any errors, but I still get the #Error in the...

Caught the mispelling after I posted the images. Fixed both issues and still get the comma error.

Here are the screen shots.

STATUS IN (@Status) --('4','10','30')