[AccessD] NZ for Null

something like this:
varValue = Format( Nz(varValue,0), "#,###")
or wahtever format you desire.

Lembit


----- Original Message ----- 
From: "Hollis, Virginia" <hollisvj at pgdp.usec.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, June 20, 2007 5:32 PM
Subject: [AccessD] NZ for Null


> Is there a way to format the number too? I want it to show 7,400.
>
>
>
>
>
> Hi Virginia,
>
> varValue = Nz(varValue,0)
>
> OR
>
> sngValue = Nz(qry_nonpurchase!SumOfUnits,0)
>
> OR
>
> Nz(tbl_InventoryCurrent!Units,0) - Nz(qry_nonpurchase!SumOfUnits,0)
> -Nz(qry_purchase!SumOfUnits,0)
>
> Look up NZ in Access Help - it gives the whole story.
>
> BOL!
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> <http://databaseadvisors.com/mailman/listinfo/accessd>
> [mailto:accessd-bounces at databaseadvisors.com
> <http://databaseadvisors.com/mailman/listinfo/accessd> ] On Behalf Of
> Hollis, Virginia
> Sent: Friday, June 15, 2007 10:49 AM
> To: accessD at databaseadvisors.com
> <http://databaseadvisors.com/mailman/listinfo/accessd>
> Subject: [AccessD] NZ for Null
>
> I am trying to get a beginning total - how do I check for Nz & then put
> a zero in if it is Null? This will be used on a report.
>
>
> Beginning:
> tbl_InventoryCurrent!Units-qry_nonpurchase!SumOfUnits-qry_purchase!SumOf
> Units
>
>
>
> Virginia
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.9.1/854 - Release Date: 19.06.2007 
> 13:12
>
>