[AccessD] NZ for Null

Steve Schapel miscellany at mvps.org
Thu Jun 21 15:25:48 CDT 2007


Virginia,

Hollis, Virginia wrote:
> .... So the report fields from the calculated query do not allow
> formats.

As mentioned in my earlier post, the reason for this is that the Nz() 
function is causing the resultant value to be treated as a string, so 
numerical format options are not made available to you.  I would use the 
Val() function to revert it to a number, and then you will see the 
numerical formats.

Regards
Steve



More information about the AccessD mailing list