How to append @email.com to a name

[mwilke1978]

I have a database that has a column for usernames. I want to create a new column called Email and run some SQL command or query that will take the username... add email.com to the end of it and place it in the email column. I think want to be able to run mail merges with that database and i know how to do that part. I just cant figure out how to append @email.com to the end of username and create a new field with the email addresses.



PS... im a complete beginner so go easy on me lol

[June7]

You want a Email field to be a Calculated type in table? Do concatenation:

[username] & "@email.com"

Is there really an email.com or is this fake just for example?

[mwilke1978]

You want a Email field to be a Calculated type in table? Do concatenation:

[username] & "@email.com"

Is there really an email.com or is this fake just for example?

The "email.com" is just a for example type thing. So my SQL line to add would simply be

[username] & "@email.com"

How does it know to populate to the new column i am dubbing "Email" ?

[June7]

It doesn't and there is no need to. Do the calc when the string is needed.

You can use a Calculated type field in table or do the calculation in query or in textbox ControlSource or in code (macro or VBA).

Saving calculated data requires code (macro or VBA). Saving calculated data is usually not a good idea. Certainly is not necessary in this case.