Ray M (11/9/2012)

---

There's 2 ways to do it.

Leave the Formula the way you have it as

=sum(Fields!selling_price.value)

and then in the properties of the Textbox change the number format (Right Click on...

Thanks Eugene,

That's perfect, It has produced almost the exact number of records I expected. It is out by less than 10 records but I can see these records are...

Yeah apologies again I copied the sql whilst half way through attempting something else...

I edited my post above but the following is produces about double my expected results...

SELECT

a.pr_id,

a.bp_id,...

It's because the SQL I copied into the forum post was wrong - I had too many windows open ...

Anyway the following SQL is what I had been attempting:

SELECT

a.pr_id,...