After append update query

[twychopen22]

I need an append query to also update a yes/no box or a text box with "yes" "no" in the field.
I don't know how to do this in SQL. Please help.
Query 1 is the name of the query I want updated from "yes" to "no"
Something like:
AFTER APPEND (I am not sure how to do the "after append" in sql)
UPDATE Query 1
SET Query 1.DueToday = "No"
Where DueToday = "Yes"

 

[FoFa]

Just create two queries, run one after the other.

 

[twychopen22]

Brilliant!!!
I got them all to work correctly. Thanks for your help!

 

[twychopen22]

When all my queries run automatically how do I get them to automatically say "ok" to the boxes that pop up?

 

[boblarson]

From Code:

SetWarnings=False
DoCmd.RunQuery "MyQueryName"
DoCmd.RunQuery "MyOtherQueryName"
SetWarnings=True

 

[twychopen22]

Where does this code go? in the queries, Ican only use SQL

 

[twychopen22]

Where does this code go? in the queries, Ican only use SQL

 

[FoFa]

Where are you running the queries from, VBA or Macro.
The example boblarson gave was if you were using VBA, if you are using a macro, use the SETWARNINGS command

 

[twychopen22]

Yeah Access, I found it Thanks so much! It works now