Your syntax is correct. You put in the WHERE clause, the same thing you would use in a SELECT statement.
>When you do an UPADTE (Tablename) SET (Field) = (Value) is there a way that you can do it in all one step if you have multiple updates to perform ie maybe something like this :
>
>UPDATE (Table)
>SET (Field1) = (Value), (Field2) = (Value), (Field3) = (Value)
>WHERE (Condition)
>
>
>???????????????
>
>Just wondering, any help would be appreciated.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com