We help IT Professionals succeed at work.

Update target table column value when source table column value is different

skull52
skull52 asked
on
124 Views
Last Modified: 2017-04-17
I have an access table tbl_Items_UPC (Target Table) with a QTYONHND column that I want to only update from dbo_SSG_UPC_SCAN (Source Table) when the source value changes. I work mostly with SQL and it has a MERGE function that does that very well. I suspect that I would have to use an update query in access to accomplish this, I have tried a couple of queries but it didn't seem to work. I am using Access 2016
Comment
Watch Question

Senior Application Developer
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
Agree with Paul's comment.
Here is an application to table a(aid, f) as source, and table b(aid, f1) as target.
Need to update f1 in target when f1 is different.
UPDATE b AS target INNER JOIN a AS source ON target.aid = source.aid SET target.f1 = source.f1
WHERE (((target.f1)<>[source].[f1]));

Open in new window

skull52IT director

Author

Commented:
Thanks Paul, I should have figured that out, that is how I would have done in in SQL if I didn't use  SQL's MERGE Function

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions