Updated Initials to Full NameI have a Table

[jlig via AccessMonster.com]

My tblSalesData has the Rep fields listed with First Initial & Last Initial
only. (ex. AE)

(Note: This table is a Linked Excel Sheet so I have no control over the
Initials input.)

I have built a tblReps that lists the Initials & the Fullname of the Rep.

Question:
--------------
How do I run an Update Query to change all the Initials in the tblSalesData
to their Full Names listed in the tblReps?

I created an Update Query that will work for 1 Rep at a time,
------------------------------------------------------------------------------
-
UPDATE SalesReport_AllCatg SET SalesReport_AllCatg.Loc = "Account Executive"
WHERE (((SalesReport_AllCatg.Loc)="AE"));
------------------------------------------------------------------------------
-
but don't know how to make it do all Reps at once.

Thanks in advance for your help!
jlig

 

[Guest]

Make a new field RepNew in your tblSalesData, then create a new query using
this SQL:

UPDATE tblReps INNER JOIN tblSalesData ON tblReps.Intials = tblSalesData.Rep
SET tblSalesData.RepNew = [FullName];

It joins tblReps.Intials to tblSalesData.Rep (since Rep is by initials now)
and pulls the associated full name from tblReps to tblSalesData.RepNew.

When done, get rid of the Reps field and rename RepNew field to Rep (you
will need to re-create any relationships that involve this field)

 

[jlig via AccessMonster.com]

Thanks Brian,
Worked great.

Make a new field RepNew in your tblSalesData, then create a new query using
this SQL:

UPDATE tblReps INNER JOIN tblSalesData ON tblReps.Intials = tblSalesData.Rep
SET tblSalesData.RepNew = [FullName];

It joins tblReps.Intials to tblSalesData.Rep (since Rep is by initials now)
and pulls the associated full name from tblReps to tblSalesData.RepNew.

When done, get rid of the Reps field and rename RepNew field to Rep (you
will need to re-create any relationships that involve this field)

My tblSalesData has the Rep fields listed with First Initial & Last Initial
only. (ex. AE)

[quoted text clipped - 20 lines]

Thanks in advance for your help!
jlig