3
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_DATA_1.NAME AS SUPERVISOR_NAME, SUM(dbo.PS_JOB.HOURLY_RT * dbo.Vac_Accrued1.Total_Vac_Earned + dbo.Floater_Balance.Total_Floater_Balance) AS Liability
FROM dbo.Floater_Balance INNER JOIN
dbo.PS_JOB INNER JOIN
dbo.Vac_Accrued1 INNER JOIN
dbo.PS_EMPLOYMENT ON dbo.Vac_Accrued1.EMPLID = dbo.PS_EMPLOYMENT.EMPLID INNER JOIN
dbo.PS_PERSONAL_DATA ON dbo.Vac_Accrued1.EMPLID = dbo.PS_PERSONAL_DATA.EMPLID ON
dbo.PS_JOB.EMPLID = dbo.Vac_Accrued1.EMPLID INNER JOIN
dbo.PS_PERSONAL_DATA PS_PERSONAL_DATA_1 ON dbo.PS_EMPLOYMENT.SUPERVISOR_ID = PS_PERSONAL_DATA_1.EMPLID ON
dbo.Floater_Balance.EMPLID = dbo.Vac_Accrued1.EMPLID
GROUP BY dbo.PS_PERSONAL_DATA.EMPLID, dbo.PS_PERSONAL_DATA.NAME, dbo.PS_EMPLOYMENT.SUPERVISOR_ID, PS_PERSONAL_DATA_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
