<div>
Glad to help!<br />
<br />
BTW, if you liked that article, please be sure to go to that link, and click 'Yes' for 'Was this helpful?'<br />
<br />
Patrick
</div>


Glad to help!

BTW, if you liked that article, please be sure to go to that link, and click 'Yes' for 'Was this helpful?'

Patrick

<div>
<div class="content wysiwyg-content">
I have an access table that looks like this: <br />
<br />
ID &nbsp; &nbsp; NAME &nbsp; &nbsp; <br />
1 &nbsp; &nbsp; &nbsp;John Dough<br />
2 &nbsp; &nbsp; &nbsp;Donald Disney<br />
3 &nbsp; &nbsp; &nbsp;Brajalenia Jollie-Pitt<br />
4 &nbsp; &nbsp; &nbsp;A. Smith<br />
5 &nbsp; &nbsp; &nbsp;James Watson<br />
<br />
I need to take the name and split into two columns; First Name and Last Name. Sadly, I know nothing about access. Can anyone help me with such a query?
</div>
</div>


I have an access table that looks like this: 

ID     NAME     
1      John Dough
2      Donald Disney
3      Brajalenia Jollie-Pitt
4      A. Smith
5      James Watson

I need to take the name and split into two columns; First Name and Last Name. Sadly, I know nothing about access. Can anyone help me with such a query?

Access SQL to &quot;UNCONCAT&quot; Column

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.

Access SQL to &quot;UNCONCAT&quot; Column

Access SQL to "UNCONCAT" Column