<div>
Thank you both, when I tried the Round() function, it seemed to work (code attached). &nbsp;But when I try to do the currency version, which I need I guess if I want to include commas for thousands separators, I get an error. &nbsp;Any idea why?<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/09_w40/503381/FormatError.JPG" target="_blank" title="MS Query-Format Error (39 KB)"><img alt="MS Query-Format Error" class="file-block lazyload" style="max-width: 451px;" data-src="https://filedb.experts-exchange.com/incoming/2011/09_w40/503381/FormatError.JPG" /></a>
</div>


Thank you both, when I tried the Round() function, it seemed to work (code attached).  But when I try to do the currency version, which I need I guess if I want to include commas for thousands separators, I get an error.  Any idea why?

 MS Query-Format Errorhttps://filedb.experts-exchange.com/incoming/2011/09_w40/503381/FormatError.JPG

FormatError.JPG

<div>
Never mind..it looks like II need to make 'currency' single quotes.. that worked.
</div>


Never mind..it looks like II need to make 'currency' single quotes.. that worked.

<div>
<div class="content wysiwyg-content">
<br />
I am working on an MS Query and have the following code:<br />
<br />
SELECT TempTable.Category, Sum(TempTable.`Dec 31, 09`), Sum(TempTable.`Dec 31, 10`), Sum(TempTable.`Jul 31, 11`)<br />
FROM TempTable TempTable<br />
WHERE (TempTable.Category&lt;&gt;'')<br />
GROUP BY TempTable.Category<br />
<br />
It produces what I expected and hoped for except for the extra long numbers. &nbsp;Can someone tell me how to convert the number to 2 decimal places with commas as thousands separators?
</div>
</div>



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
WHERE (TempTable.Category<>'')
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?

Converting number to 2-digit in MS Query

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.