How do I split a cell in access query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have names in a table in the format Last, First. I would like to split
this column in a query to creat two columns for last and first. Is there a
way to split by the comma?
 
Check Help on:
Update Query
(open module to find these topics)
Left()
Mid()
Right()
Instr()

If you can't find what you need, either search google since this question is
asked frequently or come back 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

Split data in field on character return 0
Multiple Commas 3
Access to split First and Last name 0
VBA Multiple Line handling with Split() 1
Splitting a Field Question 2
Splitting a field 1
query to split data in a column into two separate columns 10
Split the contents of a field ie - full name into first and last n 3

Back
Top