Grab first characters from field

[sau3-access]

Hello community,

Is there documentation/reading out there on how to query fields and take only a certain number of characters from said field?

We are setting up a user database on a 3rd party web application and they have a 15 character username limit so we want to pull the first 3 letters of a persons first name, middle initial, and first 4 letters of a persons last name to use as the username. We have an Access database will all of this information but I am not sure what the correct query is to complete this task.



John P Roberts = JohPRobe

Thank you ahead of time for your assistance,

SAU3 - NH

[pbaldy]

Sounds like you want the Left() function.