syntax error in multiple update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i made a multiple update query

UPDATE ROUTINDB SET ROUTINDB.[NEXT SCHEDULE DATE] =
DateAdd("m",1,ROUTINDB![SCHEDULE DATE])
WHERE (((ROUTINDB.FREQ)="1M")), ROUTINDB.[NEXT SCHEDULE DATE] =
DateAdd("m",3,ROUTINDB![SCHEDULE DATE])
WHERE (((ROUTINDB.FREQ)="3M"));

i am getting a syntax error (comma) in query expression, pls can anyone help
to remove this error. thanks
 
Zaheer,

You cannot have 2 WHERE clauses in one query (although you can have multiple
conditions in one WHERE clause), use nested IIf Statement in this case - see
my example to your previous question

Regards/JK


|i made a multiple update query
|
| UPDATE ROUTINDB SET ROUTINDB.[NEXT SCHEDULE DATE] =
| DateAdd("m",1,ROUTINDB![SCHEDULE DATE])
| WHERE (((ROUTINDB.FREQ)="1M")), ROUTINDB.[NEXT SCHEDULE DATE] =
| DateAdd("m",3,ROUTINDB![SCHEDULE DATE])
| WHERE (((ROUTINDB.FREQ)="3M"));
|
| i am getting a syntax error (comma) in query expression, pls can anyone
help
| to remove this error. thanks
| --
| Zaheer
| Acesss Database Designer
| Planning Supervisor
 
i am getting a syntax error (comma) in query expression, pls can anyone help
to remove this error. thanks
Click to expand...

UPDATE ROUTINDB SET ROUTINDB.[NEXT SCHEDULE DATE] =
DateAdd("m",IIF([FREQ] = "1M", 1, 3),ROUTINDB.[SCHEDULE DATE])
WHERE (((ROUTINDB.FREQ) IN("1M", "3M")));


John W. Vinson [MVP]
 
My pleasure

| thanks JK, i really appreciate ur help...it worked now...again many thanks
| --
| Zaheer
| Acesss Database Designer
| Planning Supervisor
|
|
| "JK" wrote:
|
| > Zaheer,
| >
| > You cannot have 2 WHERE clauses in one query (although you can have
multiple
| > conditions in one WHERE clause), use nested IIf Statement in this case -
see
| > my example to your previous question
| >
| > Regards/JK
| >
| >
| > | > |i made a multiple update query
| > |
| > | UPDATE ROUTINDB SET ROUTINDB.[NEXT SCHEDULE DATE] =
| > | DateAdd("m",1,ROUTINDB![SCHEDULE DATE])
| > | WHERE (((ROUTINDB.FREQ)="1M")), ROUTINDB.[NEXT SCHEDULE DATE] =
| > | DateAdd("m",3,ROUTINDB![SCHEDULE DATE])
| > | WHERE (((ROUTINDB.FREQ)="3M"));
| > |
| > | i am getting a syntax error (comma) in query expression, pls can
anyone
| > help
| > | to remove this error. thanks
| > | --
| > | Zaheer
| > | Acesss Database Designer
| > | Planning Supervisor
| >
| >
| >
 
Back
Top