Change blanks to 0 (zero)
I thank you Karl. Apparently, I was not putting a space in between Is and
Null. It is working fine now.
--
Jodie
"KARL DEWEY" wrote:
What can I enter in the criteria that will recognize all of the blank fields?
There are more than one thing that can appear as a blank. There are nulls
and zero lenght strings.
Use this to pull both --
Is Null OR ""
That is two double quotes.
--
Build a little, test a little.
"Jodie" wrote:
I need to do an update to change all blank fields to a 0 (zero). In the
criteria, I have tried IsNull and it is not returning any of the blank
records. I have tried IsEmpty and I get a message that say mismatch. What
can I enter in the criteria that will recognize all of the blank fields?
--
Thank you, Jodie
|