querying for the first letter of a field 1

[s0ccerdude]

I am trying to add an "email" field from a table of contact data. In the contacts table, each record consists of a "first name" and "last name" field. The email addresses for these contacts are predictable. Each follows the following format:

first letter first name + last name + extension

For instance:

Bob Smith would be bsmith@emailaddress.com

I'm looking to use a query expression to return the first letter of the first name, which I will use to concatenate with the last name and address extension. Is there a way to set up a query that returns only the first letter of the field?

 

[THWatson]

Make a new column in your query, with the expression
Left([YourFirstNameField],1)

However, might you not have more than one first name beginning with a particular letter?

Tom

 

[s0ccerdude]

Thanks for the reply THWatson! This is exactly the answer I was lookin for.