Update field to Null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update table1 based on a match to table2 3
Hiding Labels in Reports if Field Blank 2
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Set (9) fields to Null due to type conversion failure !!!! 2
Update Query Without Replacing Text 3
Null value 3
Udate query 1
SQL syntax for Update query 2

Back
Top