Change blanks to 0 (zero)
On Thu, 18 Mar 2010 10:08:01 -0700, 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?
Is Null
The blank is significant. IS NULL is a SQL criterion; IsNull() is a VBA
function. They are confusingly similar in both name and functionality but they
are not identical!
--
John W. Vinson [MVP]
|