<div>
Looks like you're missing a quotation mark...<br />
=&quot;Grand Total&quot;&amp;&quot; &quot;&amp;[Paid]
</div>


Looks like you're missing a quotation mark...
="Grand Total"&" "&[Paid]

<div>
I need the dollar sign $ and comma where ever neede.
</div>


I need the dollar sign $ and comma where ever neede.

<div>
How about a label that reads &quot;Grand total&quot; attached to the [paid] field, which is formatted as currency, left justified and has no border showing with a transparent background?<br />
<br />
I'm assuming youre doin gthis in either a form or a report - in either case it would work.
</div>


How about a label that reads "Grand total" attached to the [paid] field, which is formatted as currency, left justified and has no border showing with a transparent background?

I'm assuming youre doin gthis in either a form or a report - in either case it would work.

<div>
Example<br />
?Format(&quot;12332.33&quot;,&quot;Curren<wbr />cy&quot;)<br />
$12,332.33
</div>


Example
?Format("12332.33","Currency")
$12,332.33

<div>
<div class="content wysiwyg-content">
I have text box that read as follows:<br />
<br />
=Grand Total&quot;&amp;&quot; &quot;&amp;[Paid]<br />
<br />
I need the results to display as Grand Total $15,000.00
</div>
</div>


I have text box that read as follows:

=Grand Total"&" "&[Paid]

I need the results to display as Grand Total $15,000.00

Format the result of a sum field to display as currency

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.