A arobbo Registered User. Local time Today, 15:43 Joined Nov 22, 2004 Messages 13 Dec 16, 2005 #1 hi i've joined two tables and have some null values ..... I want these null values to be 0 to be used in a calculation anyone got any ideas how i could do this cheers Andy
hi i've joined two tables and have some null values ..... I want these null values to be 0 to be used in a calculation anyone got any ideas how i could do this cheers Andy
RuralGuy AWF VIP Local time Today, 08:43 Joined Jul 2, 2005 Messages 13,825 Dec 16, 2005 #2 Look up the Nz() function in VBA help.
