Solved

Update query involving 2 tables

Posted on 2013-05-20
2
294 Views
Last Modified: 2013-05-20
access 2013

I have database:
2 tables

tbl_Slang
3 fields
id-autonumber
fldSlang -text
fldDescriptor - text

tbl_Data
3 fields
id-autonumber
fldDescriptor
fldTerm

fldDescriptor is the common field between the two tables




What I need:
I need a vba routine that will update a field in tbl_Data(fldTerm)
with the data from the field fldSlang from the tbl_Slang Table


tbl_Slang:
fldSlang                                     fldDescriptor
TUG BOATS                                Switch Grip-lok Handy Box
TUGGER                                       Cable Puller
VERMITTI                                        Platform Lifter
WHIP                                          Electrode Holder

Before Update:


tbl_Data
fldDescriptor                                fldTerm
Switch Grip-lok Handy Box
Cable Puller
Platform Lifter
Electrode Holder


After Update:

tbl_Data
fldDescriptor                                fldTerm
Switch Grip-lok Handy Box           TUGBOATS
Cable Puller                                  TUGGER
Platform Lifter                              VERMITTI
Electrode Holder                           WHIP

Thanks
fordraiders
0
Comment
Question by:fordraiders
2 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
Comment Utility
See if this works for you:
UPDATE tbl_Data INNER JOIN tbl_Slang ON tbl_Data.fldDiscriptor = tbl_Slang.fldDescriptor SET tbl_Data.fldTerm = [tbl_Slang]![fldSlang];

Open in new window

Flyster
0
 
LVL 3

Author Closing Comment

by:fordraiders
Comment Utility
Thanks very much
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now