Update date field to Is Null in an update query

  • Thread starter Thread starter Owl
  • Start date Start date
O

Owl

In an update query I have put "Is Null" into Criteria of a date field called
RequestDate and the query works, but comes up with a message that it hasn't.
How can I improve on what I have entered in Criteria for the message not to
come up?

Thanks for any help.
 
The problem is solved. I am not sure what did it, but I think it was
RE-ENTERING the SetWarnings part of the macro AFTER I had fixed another
problem (macros such as SetValue and SetWarnings not working) with running
Microsoft Office Diagnostics. The message still comes up on the query (but
the users won't see that), but not on the form nor the report.

HOWEVER, I would very much appreciate finding out what I should enter in
Criteria for it to be absolutely correct.

Thanks again for any help.
 
Owl said:
The problem is solved. I am not sure what did it, but I think it was
RE-ENTERING the SetWarnings part of the macro AFTER I had fixed another
problem (macros such as SetValue and SetWarnings not working) with running
Microsoft Office Diagnostics. The message still comes up on the query
(but
the users won't see that), but not on the form nor the report.

HOWEVER, I would very much appreciate finding out what I should enter in
Criteria for it to be absolutely correct.

Thanks again for any help.
Click to expand...


"Is Null" would be correct in the Criteria row, but looking at the title of
your post, I wonder if perhaps you might have put "Is Null" in the "Update
To" row? It should be just "Null" in the Update To row if you are trying to
assign a null value to the field.

If that's not it, then if you post the SQL from the query (open the query in
design view and choose SQL View from the menu/ribbon) then someone will
probably be able to see what the problem is.
 
You are a star, Brendan! Yes, I did mean the Update To field. I changed it
to Null without the inverted commas and it worked perfectly! Thank you.
 
Back
Top