Update Query

[R Young via AccessMonster.com]

I have one column "EnterpriseID" which contain shortnames of 70,000
employees. I need to add "@xyz.com" to each shortname.

I do have another column with the actual email address, BUT not all the
records have an email address. 56,000 have "NA" as the email address.

I just discovered the update query but it is just not updating my records
at all. Any help would be appreciated!

 

[John Vinson]

I have one column "EnterpriseID" which contain shortnames of 70,000
employees. I need to add "@xyz.com" to each shortname.

I do have another column with the actual email address, BUT not all the
records have an email address. 56,000 have "NA" as the email address.

I just discovered the update query but it is just not updating my records
at all. Any help would be appreciated!

Answered in m.p.a.queries.

Please DO NOT MULTIPOST. If it's necessary (hint: it rarely is, most
of the volunteers here frequent several newsgroups) to post a message
in more than one newsgroup, crosspost instead by putting the two or
three (NO MORE please!) newsgroup names in the Newsgroups: line.

John W. Vinson[MVP]

 

[R Young via AccessMonster.com]

I accidentally posted to the wrong forum the first time...my mistake!
Which is why you saw the post in the correct forum (queries).

Thanks for looking out!

 

[Guest]

Hi,

In the update query, in the field that you want to
update, enter [EnterpriseID]&"@xyz.com" in the "Update
To:" line.

Hope this helps.