Formatting report after use of NZ function

  • Thread starter Thread starter dje
  • Start date Start date
D

dje

Sorry one other point. Having used the NZ([ ],0) function, I cannot select
the standard format. Is there any way of inserting commas and 2 decimal
points into the report?

Thanks
 
Sorry one other point. Having used the NZ([ ],0) function, I cannot select
the standard format. Is there any way of inserting commas and 2 decimal
points into the report?

Thanks
Click to expand...

=Format(Nz([FieldName],0),"#,##0.00")
 
thanks for your assistance - obvious answer but beyond my limited
understanding of access.

fredg said:
Sorry one other point. Having used the NZ([ ],0) function, I cannot select
the standard format. Is there any way of inserting commas and 2 decimal
points into the report?

Thanks
Click to expand...

=Format(Nz([FieldName],0),"#,##0.00")
Click to expand...
 
Try using

CCUR( NZ([ ],0))
or
CDbl( NZ([ ],0))

That should force the datatype to a numeric type and Access should display
the formats for numbers

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top