Show First 6 Characters

  • Thread starter Thread starter Alec Green
  • Start date Start date
A

Alec Green

Try Again!

I would like to show the first 6 characters of my customer field in my
query, can anyone help

ie Customer: Joe Bloggs

returns Joe Bl

Thanks
 
Use the LEFT function.

Field: First6: LEFT([CustomerField],6)

In an SQL Statement

SELECT LEFT([CustomerField],6) As First6, ...
 
Back
Top