Show First 6 Characters

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
 
J

John Spencer (MVP)

Use the LEFT function.

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

In an SQL Statement

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