Trim 2 fields to get initials 1

[dcurtis]

I have 2 fields (Last_Name and First_Name). I need to create a field that will have the initials. I think I need to use RTRIM but I don't know how to tell it to get just first letter of each field. On line help hasn't been very. Thanks in advance for your help.

----
Access 2002 on a mixed Windows OS network.

 

[SteveR77]

You will need a Left function on the name fields.

Left([Name],1)

 

[dcurtis]

Perfect, thanks!