How do I split a cell in access query

R

raw2136

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?
 
D

Duane Hookom

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.
 
Top