Update 2 tables with one Update Query

[Douglasrac]

Here is what I did:

UPDATE TableName, TableName2
SET FieldName = TRUE And FieldName2 = True
WHERE ((FieldName = False) AND (FieldName2 = False))

But didn't work. And as I read, Access can't run multiple statements in one query. So I need to found another solution. Why the code above does not work?

[Rixxe]

Why can you just not run two seperate queries?

I don't understand why you would need to do this.

[Rixxe]

This might do it:

UPDATE Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID SET Table1.ID ="200",
Table2.ID = "200" WHERE Table2.ID="1000"

[Douglasrac]

This might do it:

UPDATE Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID SET Table1.ID ="200",
Table2.ID = "200" WHERE Table2.ID="1000"

Because its seems such a simples task, so I don't want to make 2 very simples queries to do one simple task.

I don't understand the numbers. 200 and 1000. What that's suppose to be?

[Rixxe]

Its an example, you can just replace:

Table1.ID ="200"

with

TableName.FieldName = TRUE

Just change it accordingly and try the query out and see if it works... and just FYI sometimes doing it the simple way isn't a bad thing.
You could go round the houses to update a table, or just do it the easy way and save yourself time.

Maybe someone else might have an idea.