Update Query - Not working

  • Thread starter Thread starter scharp1n2
  • Start date Start date
S

scharp1n2

I have attached my sql which does not seem to work.

UPDATE Material1A INNER JOIN war100708 ON Material1A.KishMaterialID =
war100708.KishMaterialID SET war100708.SKUNumber = Material1A!WARSKU;

It deletes the sku number from the original table (war100708) but it does
not seem to end up in the Material1A table.

I am using Access2003 -

Thank you in advance for any help on resolving this.
 
"it does not seem to end up in the Material1A table" because you are updating
the war100706 table with this set:
SET war100708.SKUNumber = Material1A!WARSKU
 
Thank you so much - you can not imagine how much time I wasted. It works
great now. Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update query issue 0
Max or DMax - Issue 8
Pulling data out and understanding total queries 3
Update Query ODBC --- call failed 11
Getting Multiple Queries to work 6
Incorrect sum in MS Access query 1
Delete query with joined tables 0
How does one report a bug in Access 2007 SQL? 4

Back
Top