Formatting in access SQL 2

[SQLScholar]

Hey all,

thanks to some sage advice earlier, i nearly have the exact report i want.

Only difference is that currently all my values (i have used round(,2)) are only rounded to 2 DP. What i really would like is to format them so there £##.## or similar.

Hopefully then when the csv it outputs, is opened in excel, it will realise there £££££.

Thanks in advance

D

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[SQLScholar]

Sorted it - its this really odd program we use.

I needed to use

format(`Insurer_Accounts`.Gross,'Currency') AS Gross,

Thanks dude - STAR.

D

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!