The key is to wrap every field or value in an Nz () function, not the entire expression. For instance, the following expression has the potential to return #Error, despite the Nz () function: ...