J jamphan Registered User. Local time Today, 15:11 Joined Dec 28, 2004 Messages 143 Aug 16, 2007 #1 I would like to sum a series of fields on my Form but for some reason if there is not a value in one of the fields it will not sum any of them. What can I do to get it to sum even if all the fields do not have values? Thanks!
I would like to sum a series of fields on my Form but for some reason if there is not a value in one of the fields it will not sum any of them. What can I do to get it to sum even if all the fields do not have values? Thanks!
neileg AWF VIP Local time Today, 23:11 Joined Dec 4, 2002 Messages 5,975 Aug 16, 2007 #2 Any sums that include nulls will produce a null answer so use Nz() the null to zero function on each of the fields in the equation.
Any sums that include nulls will produce a null answer so use Nz() the null to zero function on each of the fields in the equation.
Rabbie Super Moderator Local time Today, 23:11 Joined Jul 10, 2007 Messages 5,906 Aug 16, 2007 #3 Use the NZ function. This will convert a null value to zero and let you generate the total. =nz(field1) + nz(field2) + nz(field3) HTH
Use the NZ function. This will convert a null value to zero and let you generate the total. =nz(field1) + nz(field2) + nz(field3) HTH
