using currency in a stored procedure

[Routergal]

Dear SQL gurus,

I am so new at this, as a matter of fact this is my first Access Database front-end with a SQL back-end. I wrote a stored procedure to show liability for vacation accrued:

SELECT dbo.PS_PERSONAL _DATA.EMPLID, dbo.PS_PERSONAL _DATA.NAME, PS_PERSONAL_DAT A_1.NAME AS SUPERVISOR_NAME , SUM(dbo.PS_JOB. HOURLY_RT * dbo.Vac_Accrued 1.Total_Vac_Ear ned + dbo.Floater_Bal ance.Total_Floa ter_Balance) AS Liability
FROM dbo.Floater_Bal ance INNER JOIN
dbo.PS_JOB INNER JOIN
dbo.Vac_Accrued 1 INNER JOIN
dbo.PS_EMPLOYME NT ON dbo.Vac_Accrued 1.EMPLID = dbo.PS_EMPLOYME NT.EMPLID INNER JOIN
dbo.PS_PERSONAL _DATA ON dbo.Vac_Accrued 1.EMPLID = dbo.PS_PERSONAL _DATA.EMPLID ON
dbo.PS_JOB.EMPL ID = dbo.Vac_Accrued 1.EMPLID INNER JOIN
dbo.PS_PERSONAL _DATA PS_PERSONAL_DAT A_1 ON dbo.PS_EMPLOYME NT.SUPERVISOR_I D = PS_PERSONAL_DAT A_1.EMPLID ON
dbo.Floater_Bal ance.EMPLID = dbo.Vac_Accrued 1.EMPLID
GROUP BY dbo.PS_PERSONAL _DATA.EMPLID, dbo.PS_PERSONAL _DATA.NAME, dbo.PS_EMPLOYME NT.SUPERVISOR_I D, PS_PERSONAL_DAT A_1.NAME


In the section where it is underlined there is a sum of several columns AS "Liability" I would like the total in Liability to be currency. How do I do that?

Any help would be greatly appreciated.

Lucinda

[ck9663]

Convert that portion to money...

 
cast(SUM(dbo.PS_JOB.HOURLY_RT * dbo.Vac_Accrued1.Total_Vac_Earned + dbo.Floater_Balance.Total_Floater_Balance)  as money) as Liability
 
 

Happy Coding!!!

~CK