Thanks all - really appreciate your time and help.

Thanks all.

John's post worked fine.

Thanks again.

The expression worked fine.

Thanks for the reply but this did not work. It returned 'Error'.

I have found a solution elsewhere in case your are interested:

=Sum(iif(Fields!Exposure.Value < 10000, CDbl(Fields!Disbs.Value), CDbl(0)))

I have no idea what...

Thanks Lowell.

I'm currently getting an error message with this statement and can't place my finger on why:

"Error in SELECT clause: expression near ','.

Missing FROM clause.

Unable to parse query text."

Followed...