The last thing I built was using Arduino, a GSM shield and relay. It acts as as an override to turn the central heating on with a text message /...

Can't you just check the 'Use 1000 separator (,)'?

No problem, it doesn't help when it's not a 'logical' request!

It's a work around up to a point, but by definition it's per page. I've made the pages as large...

I think I've found a way to achieve what I want.

I've added a page header with a text box / placeholder, and use the formula '=Sum(ReportItems("TotalTurnover").Value)'

Hi Jack,

Many thanks for that but unfortunately it's not what the user wants!

The total turnover figure represents the total turnover across all sectors, not the specific sector. So if someone...

I hope this works!

I've written this quickly as an example, I'll try to put a proper example together shortly.

select

'Fred Bloggs' as Name,

'Sky Hooks' as Sector,

8005.23 as TotalTurnover

UNION

Select

'Fred Bloggs',

'Pith Helmets',

8005.23

UNION

Select

'Fred Bloggs',

'Unicycles',

8005.23

UNION

Select

'Brenda Bloggs',

'Sky Hooks',

11005.56

UNION

Select

'Brenda Bloggs',

'Unicycles',

11005.56

UNION

Select

'Brenda...

Thanks Jack but I've already explored that one. I'm hoping that someone might have an idea along the lines of 'sum of displayed figures'!

If you run the following script:

SELECT

description

,COLLATIONPROPERTY(name, 'CodePage') AS CodePage

,COLLATIONPROPERTY(name, 'LCID') AS LCID

FROM fn_helpcollations()

WHERE name = N'Latin1_General_CS_AS';

(apologies to the original author, I can't remember where I got it from!)

This will give...

I have to admit that I didn't 'get' this until I started to read the responses on here... :blush: