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
[]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show First 6 Characters 1
Show First 10 Characters 1
Query to return only one value. 5
Multiple rows in query 2
time issue 2
hopefully quick question 2
Update primary key field with multiple "where" clauses 0
Changes Since Moving to Exchange 3

Back
Top