Auto create email address?

[ChunkyChats]

Hi,

I'm very new to all this so please forgive me if this is well known. I have searched but don't seem to be able to find it.

I have created an employee table which has fields for first and last names. Our company email address is a standard one based on First.Last(at)Companyname.com

Is it possible to auto populate an email address in another field based on the first and last names?

Many Thanks

Steve

 

[Galaxiom]

Normally you would not store the email address if it can be derived from other data.

In a query designer field:

Email:FirstName & "." & LastName & "@" & "companyname.com"