Update query

  • Thread starter Thread starter Raymond
  • Start date Start date
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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top