Solved: Batch update

[better]

Hello again!

Okay,

Table [Clients] Table [WIP]
ClientID - (AN/PK) JobNumber - (Text, PK)
Client - (Text, I, ND) <=== 1 : Many==> Project Name - (Text)
ClientID - (N, I, ND) <- Empty

I need to UPDATE [WIP].[ClientID] SET (SELECT (ClientID) FROM (Clients) WHERE (Client) = [WIP].[Project Name])

...for every record in [WIP].

Any idea how to accomplish this easily?

Thanks!

[XLGibbs]

Update WIP
Set ClientID = a.ClientID from Clients a Inner join WIP b on a.Client = b.ProjectName



Setting the update statement up as a join would do it as above...

[better]

Man you rock!

:thumb

[XLGibbs]

Happy to help out.