Adding data to the end of every value in a field

  • Thread starter Thread starter Elisabetta
  • Start date Start date
E

Elisabetta

I have one field containing people's user names and want to add the domain
name at the end of each (the domain name is the same for everybody). There
must be a simple way to do this.
 
Hi Elisabetta,
you can use an update query to do this.
Create a query using the table of people's names and put just the one field
in it - the person name field.
Change the query to an update query.
In the UpdateTo row of the query, type
[NameOfTable].[NameOfField] & " TheDomainName"
Click the run icon to do the update and you are done.

Replace NameOfField with the name of the field that has the person's names
and similar for NameOfTable.
Replace TheDomainName with the name of the domain.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top