Hi Guys,
A complete noob here so be gentle.
I have this statement (compiled from examples I have found on the web) which works fine, however I want the 'totalsales' column to be formatted into a currency format.
set dateformat dmy
SELECT convert(varchar,ChitClosedDateTime,103) ChitClosedDateTime, EmployeeNumber, SUM (ChitTotalAmount) as TotalSales
FROM COReMicrosChitInterface
where EmployeeNumber between 1 and 200
and ChitClosedDateTime between convert(datetime, '11/10/2006 00:00') and convert(datetime,'12/10/2006 23:59')
GROUP BY convert(varchar,ChitClosedDateTime,103), EmployeeNumber
order by totalsales desc
I have found this bit of code
SELECT '£' + Convert(Varchar, ChitTotalAmount) AS totalsales
but am unsure of where to put it.
any assistance greatfully recivied.
thanks
Kev
A complete noob here so be gentle.
I have this statement (compiled from examples I have found on the web) which works fine, however I want the 'totalsales' column to be formatted into a currency format.
set dateformat dmy
SELECT convert(varchar,ChitClosedDateTime,103) ChitClosedDateTime, EmployeeNumber, SUM (ChitTotalAmount) as TotalSales
FROM COReMicrosChitInterface
where EmployeeNumber between 1 and 200
and ChitClosedDateTime between convert(datetime, '11/10/2006 00:00') and convert(datetime,'12/10/2006 23:59')
GROUP BY convert(varchar,ChitClosedDateTime,103), EmployeeNumber
order by totalsales desc
I have found this bit of code
SELECT '£' + Convert(Varchar, ChitTotalAmount) AS totalsales
but am unsure of where to put it.
any assistance greatfully recivied.
thanks
Kev