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, thus
the reasoning for wanting to add the "@xyz.com".

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

 

[Guest]

Make this an additonal field:

SELECT tablename.EnterpriseID, [EnterpriseID]+"xyz.com" AS [Both]
FROM tablename;

or you could run the update query but make the criteria "NA". The update to
should have [tablename]![EnterpriseID+"xyz.com"]

Hope this helps.
Splendalisa

 

[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, thus
the reasoning for wanting to add the "@xyz.com".

Something like this (in the SQL window, edited to use your table and
fieldnames) should work, and will preserve existing email addresses
(remove the WHERE clause if you want to stomp on them regardless):

UPDATE yourtable
SET (e-mail address removed)