Adding a field

[arpitraval]

Hi all,

I am using MS Access 2007 and in one query what i need is to add @yahoo.com to a list of 2000 users. i have already joined their first name and last name but now i want to add @yahoo.com after their name.

reply me ASAP.

Thanks
Arpit Raval

 

[MSAccessRookie]

If it is just a query in SQL format, it would be like the following:

MyTable.Name & "@yahoo.com" AS Email

In design view it looks something like:

Email: MyTable.Name & "@yahoo.com"

 

[arpitraval]

Thanks man...

That works. I appreciate it.