Formatting report after use of NZ function

[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

 

[fredg]

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

=Format(Nz([FieldName],0),"#,##0.00")

 

[dje]

thanks for your assistance - obvious answer but beyond my limited
understanding of access.

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

=Format(Nz([FieldName],0),"#,##0.00")

 

[John Spencer]

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
..