Show first 6 characters

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

Alec Green

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
 
Create a Calculated Field in your Query:

Customer: Left([CustField], 6)

Note: If the Field name in your Table is "Customer" , you will need to use a
different name for the Calculated Field above.
 
....get away, he's mine<g>
and why didn't you ring back - slacker.

peter walker
[]
 
Back
Top