T
Ted Allen
You can use the Nz() function to replace a null to
whatever value you wish. The format is:
Nz(expression, value)
where expression could be a single field name or more
complex expression, and value can be numeric (such as 0
in your case), or a string enclosed in quotes.
HTH, Ted Allen
whatever value you wish. The format is:
Nz(expression, value)
where expression could be a single field name or more
complex expression, and value can be numeric (such as 0
in your case), or a string enclosed in quotes.
HTH, Ted Allen