Breaking up a name

  • Thread starter Thread starter Randy Howard
  • Start date Start date
R

Randy Howard

How could I break a field (NAME) which contains the data value SMITH
JOHN into 2 fields (LAST NAME) (FIRST NAME).
 
Randy,

Look in the Help file for the Instr function. Use it to find the space or comma
between the Last Name and First Name. Also look up the Left function which you
need to get the Last Name and look up the Mid function which you need to get the
First Name. If you need any outside help with your application, note that I am
in business as a resource for help with Access.
 
You must log in or register to reply here.

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

help with expression to display customer details 2
Excel Comparing two columns 1
Divide One Field into 3 parts 8
Split data to 2 new fields 9
Windows 10 How to sort an index created in Word 2013 0
Separating data & Sorting: is it possible? 3
I can't believe it's been 5 years... hello! (again) 9
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top