Am trying to perform a batch update (reset records to '' or Null) on my database. Have figured out how to do that with alpha/numeric fields but am having trouble with boolean. What I have so far is:
cn.Execute "Update mytablename" & _
" Set myfldname = Null" 'or
" Set myfldName = ''"
When I do the same for a boolean field, the field does not change in the database if it is checked.
Any help is appreciated.
Thanks
Kim
cn.Execute "Update mytablename" & _
" Set myfldname = Null" 'or
" Set myfldName = ''"
When I do the same for a boolean field, the field does not change in the database if it is checked.
Any help is appreciated.
Thanks
Kim