I basically just want to show "Product code is: " (Fields!ProdCode.Value) if there is one and iif(isnothing(Fields!ProdCode.Value), "No Product Code".

So if you can't do this in a iif statement what...

Here is a rough example of what i have.

SELECT Distinct Column1, Column2, Column3, Column4, Column5,

...

It worked!

Could anyone go into detail about what this actually means ?

postdate>= dateadd(dd, datediff(dd, 0, getdate()), 0) and postdate < dateadd(dd, datediff(dd, 0, getdate()) + 1, 0)

I'm glad this...

Is getdate the same as curdate?

If so how would i use the example in the link to show the beggining of the current day thru the end of the current...