Error in update query

[morgan]

Hi everyone,
I have the following query to update a table but it returns an error that
sounds something like that: <It's not possible to repete the name of table
"T_CC_comune" in the FROM clause>. (My Access version is in Italian)
What is wrong?

UPDATE T_CC_comune, T_CC_comune SET T_CC_comune.Causale = "STIPENDIO
GLORIA", T_CC_comune.[Centro Costo] = "stipendio gloria"
WHERE (((T_CC_comune.Causale) Like "*stipendio*") AND
((T_CC_comune.Descrizione) Like "*gloria*") AND ((T_CC_comune.[Data
Operazione]) Between Date() And DateAdd("m",-2,Date())));

 

[Allen Browne]

Try:
UPDATE T_CC_comune
SET T_CC_comune.Causale = "STIPENDIO GLORIA",
T_CC_comune.[Centro Costo] = "stipendio gloria"
WHERE ...

It's acutally the UPDATE clause, but the table you are updating must be
shown once only (even though you are updating 2 fields.)

 

[morgan]

Thks Allen. It works in this way.

Try:
UPDATE T_CC_comune
SET T_CC_comune.Causale = "STIPENDIO GLORIA",
T_CC_comune.[Centro Costo] = "stipendio gloria"
WHERE ...

It's acutally the UPDATE clause, but the table you are updating must be
shown once only (even though you are updating 2 fields.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi everyone,
I have the following query to update a table but it returns an error that
sounds something like that: <It's not possible to repete the name of table
"T_CC_comune" in the FROM clause>. (My Access version is in Italian)
What is wrong?

UPDATE T_CC_comune, T_CC_comune SET T_CC_comune.Causale = "STIPENDIO
GLORIA", T_CC_comune.[Centro Costo] = "stipendio gloria"
WHERE (((T_CC_comune.Causale) Like "*stipendio*") AND
((T_CC_comune.Descrizione) Like "*gloria*") AND ((T_CC_comune.[Data
Operazione]) Between Date() And DateAdd("m",-2,Date())));