<div>
or you can directly using Format like this to show Currency in Format you want:<br />
<br />
SELECT Format([UnitPrice],&quot;##,##0<wbr />.00&quot;) AS Pr<br />
FROM Products;
</div>


or you can directly using Format like this to show Currency in Format you want:

SELECT Format([UnitPrice],"##,##0.00") AS Pr
FROM Products;

<div>
You can use CCur...<br />
<br />
&quot;Where salary = ccur(&quot;&quot;&quot; &amp;&nbsp;Format$(MyCurrencyValue) &amp;&nbsp;&quot;&quot;&quot;)&quot;<br />
<br />
That use the &quot;regional setting&quot;<br />
<br />
Good Luck!<br />
Phil.
</div>


You can use CCur...

"Where salary = ccur(""" & Format$(MyCurrencyValue) & """)"

That use the "regional setting"

Good Luck!
Phil.

<div>
<div class="content wysiwyg-content">
This function is listed with the other Format(), but when I try to use the FormatCurrency in a Query, or Report I get only errors, as though it does not recognize this Function. Is this documented &nbsp;somewhere? What's up with the FormatCurrency?
</div>
</div>


This function is listed with the other Format(), but when I try to use the FormatCurrency in a Query, or Report I get only errors, as though it does not recognize this Function. Is this documented  somewhere? What's up with the FormatCurrency?

FormatCurrency()

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.