Update query

R

Raymond

Hi everyone,

I've got the following problem. I've got 2 tables. The
first table is tblPercentage, the second is
view_Leverancierskoppel. Both tables hold the name of a
company which is related to a companynumber.
What I want to do is update the tblPercentage if the
view_Leverancierskoppel holds a filled and different
companyname. What I built so far is:

UPDATE tblPercentages
LEFT JOIN view_Leverancier ON
tblPercentages.Leveranciersnr =
view_Leverancier.LeveranciersnrNieuw
SET tblPercentages.Leveranciersnaam = [view_Leverancier].
[leveranciersnaamnieuw];

This doesn't work, the query says I should do this on a
query that can be updated, the problem is probably that is
tries to put al the updates to one record..
How can I achieve that the table is updated correctly? The
version I use is Access97. One other thing, I've created
the view_Leverancierskoppel for the reason that this way I
have a "DISTINCT" list of the table, so no doubles are
found here!

TIA, Raymond
 
M

[MVP] S. Clark

Access is pretty fickle about performing Action Queries sometimes. Delete
and Update queries often cannot be executed as easily as one would think
they should(Read: Personal Pet Peeve). Sometimes performing an intermediate
step, such as writing the data to a temp table, then performing the action
query will help you achieve your final goal.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Top