Calculated text field

[mandy4514]

I am trying to calculated our companies email addresses instead of having to enter them. I need it to come out as follow:

[FirstName].[LastName]@company.com

Please help.

Thanks,
Mandy

 

[Beetle]

You could just concatenate the values in a query field;

EMail: [FirstName] & "." & [LastName] & "@yourcompanyname.com"