i have a field called loan amount is there a way to put a 0 in this field if it is null
D dan Nov 10, 2004 #1 i have a field called loan amount is there a way to put a 0 in this field if it is null
K Ken Snell [MVP] Nov 10, 2004 #2 Use a calculated field in place of the real field when you create the query: MyLoanAmount: Nz([loan amount], 0) The Nz function can be used to replace a Null value with whatever value you specify as the second argument -- above, it's a zero.
Use a calculated field in place of the real field when you create the query: MyLoanAmount: Nz([loan amount], 0) The Nz function can be used to replace a Null value with whatever value you specify as the second argument -- above, it's a zero.
