J Joshua A. Booker Aug 20, 2003 #2 Please rephrase the queestion. If you're trying to check if a field is null, use the function IsNull(). If you want to convert Nulls to Zero or a zero length string use the Function NZ(). HTH, Josh
Please rephrase the queestion. If you're trying to check if a field is null, use the function IsNull(). If you want to convert Nulls to Zero or a zero length string use the Function NZ(). HTH, Josh