Update Query "Only Update if Field is blank"

  • Thread starter Thread starter Amy Adams via AccessMonster.com
  • Start date Start date
A

Amy Adams via AccessMonster.com

I have an Update query that currently populates 2 fields.

Field1:ClosedNewPtsCheckbox
Field2:Effective

Field 1 is updated to True (as it is a checkbox), and Filed 2 gets updated
to N/A.

Is there a way to use the criteria in this query to only update Field1 and
Field 2 if the table field that is being updated is blank?

For example I do not want to populate the Effective field if it has a date
to N/A, but if no date exists I would like it to update to N/A.

I hope this makes sense.

Thanks for the help.
Amy
 
Hi Amy,

If you are using the query designer, just add the criteria "Is Not Null"
(without the quotes) to the criteria line below field 2.

HTH, Ted Allen
 
This is code that goes in the form correct? Not code that goes into the
criteria of the update query?

If this is true do you know any solutions to insert into the criteria for
the update query?

Thanks so much for your help. As its greatly appreciated.
 
Thanks actually Is Null worked for what I was trying to do. Thanks!
 
Oops, yeah that would work better wouldn't it. Glad you got it to work,
sorry about the typo.

-Ted
 
Back
Top