Extraction of first 3 characters

[goldmedallist]

I am trying to write a query to extract the first 3 characters from a character string but have no idea where to start since we usually use Select "field" etc etc

Example, for a Code ACC01, the query result should give ACC

Would appeciated any guidance. Thank!

TK

 

[MStef]

Hello goldmedallist!
Look at "DemoLeftA2000.mdb"

 

[BryanT]

Hello goldmedallist

Try
Select Left(YourFieldName,3) From YourTableName

Bryan

 

[goldmedallist]

Hello MStef and Bryan,

Thank you very much for both your assistance It works perfectly!

Warm regards