Pull first 3 characters out of the data field

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

My USERID field have data like "EDD - VBTCP,RF1".
How can I use query to show in another field that pull
only the first 3 charaters "EDD" and igore the rest?
Please help!
Thanks
 

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

Getting #Num! in my ACCESS query 2
Split data in field on character return 0
sum field name is single character 2
Include first 3 characters in results 4
complex query to pull unique values 6
Saved query doesn't select all info in Memo field. 6
date calculation 5
Fields with Data only 7

Back
Top