A amunafc Registered User. Local time Today, 08:56 Joined Dec 17, 2009 Messages 62 Dec 17, 2009 #1 I have over 300, 000 records in MS Access 2003 and most of fields have null values and would like to replace them with Zeros (0s)
I have over 300, 000 records in MS Access 2003 and most of fields have null values and would like to replace them with Zeros (0s)
RuralGuy AWF VIP Local time Yesterday, 23:56 Joined Jul 2, 2005 Messages 13,825 Dec 17, 2009 #2 Have you looked at the Nz() function?
A amunafc Registered User. Local time Today, 08:56 Joined Dec 17, 2009 Messages 62 Dec 17, 2009 #3 I dont know how to place that NZ in my query. Please assist.
E exzant New member Local time Yesterday, 22:56 Joined Sep 11, 2009 Messages 4 Dec 17, 2009 #4 try this nz([value]) replace value with your own field
A amunafc Registered User. Local time Today, 08:56 Joined Dec 17, 2009 Messages 62 Dec 17, 2009 #5 @exzant and RuralGuy lets go on yahoo IM: my yahoo ID is freching@yahoo.com
A amunafc Registered User. Local time Today, 08:56 Joined Dec 17, 2009 Messages 62 Dec 17, 2009 #6 I think thus where we can chat without any problem
RuralGuy AWF VIP Local time Yesterday, 23:56 Joined Jul 2, 2005 Messages 13,825 Dec 17, 2009 #7 The useful way to use Nz() is: Nz([YourField],0) which will return [YourField] unless it is Null in which case it will return a 0.
The useful way to use Nz() is: Nz([YourField],0) which will return [YourField] unless it is Null in which case it will return a 0.
