title: Access query to currency
body: <p>I am have been trying to convert results in a list box to currency.</p>
  
  <p>Usually I would use:</p>
  
  <pre><code>format([Field]),"currency")
  </code></pre>
  
  <p>This didn't work and tried for a while, so I used a quick fix of:</p>
  
  <pre><code>"£" &amp; sum([Field])
  </code></pre>
  
  <p>In the short term this gives me what I want, however this causes the <strong>£</strong> to show even if they didn't log in to the system yesterday. So If nothing is found I need it to just show as blank, I thought the following would work but didn't:</p>
  
  <pre><code>NZ("£" &amp; sum([Field]),"")
  </code></pre>