Dollar sign

[Eddyoftheyear]

I have the following query that I tried everyway to place $ to the year field since it is currency, when I click propertiy for the field and select $, it will not show in the output. Any suggestions on how to go about resolving this.

TRANSFORM Sum(ByYear_All_DepartmentalSupport_qry.Amount) AS SumOfAmount
SELECT ByYear_All_DepartmentalSupport_qry.Division, ByYear_All_DepartmentalSupport_qry.[Project Name], Sum(ByYear_All_DepartmentalSupport_qry.Amount) AS [Total Of Amount]
FROM ByYear_All_DepartmentalSupport_qry
GROUP BY ByYear_All_DepartmentalSupport_qry.Division, ByYear_All_DepartmentalSupport_qry.[Project Name]
PIVOT ByYear_All_DepartmentalSupport_qry.Years;

 

[randy700]

The $ is only a display symbol.
Why would you need to see it in the query output.
Just format the object (i.e. textbox) where you display it.


Randy