I am working on an MS Query and have the following code:
SELECT TempTable.Category, Sum(TempTable.`Dec 31, 09`), Sum(TempTable.`Dec 31, 10`), Sum(TempTable.`Jul 31, 11`)
FROM TempTable TempTable
GROUP BY TempTable.Category
It produces what I expected and hoped for except for the extra long numbers. Can someone tell me how to convert the number to 2 decimal places with commas as thousands separators?