Update except for this list...

[susan]

I have an update query that does this for a list of vendors:

UPDATE tblPPVoutput SET tblPPVoutput.[Variance Category/Other Part
Classification] = "Rebill"
WHERE (((tblPPVoutput.[Fixed Std])=0));

Here's the flow of things:
1. a IIf statment in a prior query classified the "Variance Category/Other
Part Classification" in tblPPVoutput as Economics or Performance.
2. the query above update the "Variance Category/Other Part Classification"
to Rebill if Fixed Std = 0

It is working fine but now I need to modify:
I have a list of vendors (as a table in db) that I don't want to update to
"rebill" so how do it tell the query to Update to "Rebill" if Fixed Std = 0
EXCEPT for vendors on list?

Please help! Let me know if you need additional information!

Thankyou for your time!!!
Susan

 

[Dennis]

UPDATE [tblPPVoutput] LEFT JOIN Vendors ON [tblPPVoutput].[Vendor Code] =
Vendors.[Vendor Code] SET [tblPPVoutput].[Variance Category/Other Part
Classification] = "Rebill"
WHERE ((([tblPPVoutput].[Fixed Std])=0) AND ((Vendors.[Vendor Code]) Is
Null));

 

[susan]

Thanks Dennis!

UPDATE [tblPPVoutput] LEFT JOIN Vendors ON [tblPPVoutput].[Vendor Code] =
Vendors.[Vendor Code] SET [tblPPVoutput].[Variance Category/Other Part
Classification] = "Rebill"
WHERE ((([tblPPVoutput].[Fixed Std])=0) AND ((Vendors.[Vendor Code]) Is
Null));

I have an update query that does this for a list of vendors:

UPDATE tblPPVoutput SET tblPPVoutput.[Variance Category/Other Part
Classification] = "Rebill"
WHERE (((tblPPVoutput.[Fixed Std])=0));

Here's the flow of things:
1. a IIf statment in a prior query classified the "Variance Category/Other
Part Classification" in tblPPVoutput as Economics or Performance.
2. the query above update the "Variance Category/Other Part Classification"
to Rebill if Fixed Std = 0

It is working fine but now I need to modify:
I have a list of vendors (as a table in db) that I don't want to update to
"rebill" so how do it tell the query to Update to "Rebill" if Fixed Std = 0
EXCEPT for vendors on list?

Please help! Let me know if you need additional information!

Thankyou for your time!!!
Susan