Update field to Null

G

Glenda

I am trying to run an update query to set a field to Null. I've tried to use
NULL in the Update to row and I've tried to use '' and I've tried to use "".
My message states that 0 row will be updated.
 
V

Van T. Dinh

Make sure the Field you are trying to update can accept Null and post the
SQL String of your Query.

You may have some criteria that select no Records for update and hence
Access states 0 row will be updated.
 
Top