Merging The first Charcter of 3 seperate Fields

[paul29berks]

I have 3 seperate fields:

Firstname
Second name
Third name

I only require the first initial from each field. i.e

Firstname = Paul
Second Name = Dave
Third name = John

would be represented as PDJ

Can anyone help.

Thanks

 

[SydneyGeek]

Build a query expression:
=Left([FirstName],1) & Left([Second Name],1) & Left([Third Name],1)

Denis