View Single Post
  #1  
Old March 18th, 2010, 05:08 PM posted to microsoft.public.access.tablesdbdesign
Jodie
external usenet poster
 
Posts: 36
Default Change blanks to 0 (zero)

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