Format a Query Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to format a query field to only display 2 digits to the right of
the decimal. The field is an expression that I built as =Round((IIF
Statement),2). This rounds the numerical results but if the field the
statement is dependent upon is null, I get a #Error. Can someone tell me
what I am doing wrong?
 
try that
select format(nz(MyFieldName,0),"#.##"),b,c from ....

use the nz function before your field ,so it will return a 0 instead of null
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Appending Rounds Decimal to Whole Number 9
Where/how to set rounding property for a Query field 7
How do you turn off automatic rounding in a query IIf statement? 2
Query Criteria IIf statement 4
Formatting a percent field 1
Format a percent field 1
Query Calculation Decimal Point Removal 7

Back
Top