G
Guest
Sorry for cross posting this, I posted by mistake in formscoding....
I have a qry that looks at 5 tables. I found an article that says if any of
the records contain Null values, the qry will not return those records. It
says to use the Nz function to convert the Null's to zeros or zero length
strings.
My questions is, how? I can't find any examples of how to do this. Does the
Nz function go in the default value for the field in the table? If so, what
is the format?
I've tried what I could think of, but nothing has worked, and I just don't
have enough experience doing this yet.
Cheers
I have a qry that looks at 5 tables. I found an article that says if any of
the records contain Null values, the qry will not return those records. It
says to use the Nz function to convert the Null's to zeros or zero length
strings.
My questions is, how? I can't find any examples of how to do this. Does the
Nz function go in the default value for the field in the table? If so, what
is the format?
I've tried what I could think of, but nothing has worked, and I just don't
have enough experience doing this yet.
Cheers