Retrieving first character (initial) from forename (1 Viewer)

[jagstangman]

hi, im a bit stuck. i am creating a mail merge and i want access to retrieve only the first character of the forename to input into the mail merge.

e.g. Dear Mr. R Price.

I want the 'R' to be retrieved by access from the full forename, so 'R' would be retrieved from the name Robert in the forename field.


Thx

 

[Matt Greatorex]

Left(Forename,1)

 

[jagstangman]

ooh, quick reply. Thx.

Edit: where do i put this?

 

[Matt Greatorex]

You're welcome.

 

[Pat Hartman]

In your query.

Select Left(forename, 1) as FirstInitial, SurName, ....
From YourTable;