<div>
Actually, I think the last name could be multi-word - but not the first name. &nbsp;Otherwise the expressions will fail on first names like Mary Jane.
</div>


Actually, I think the last name could be multi-word - but not the first name.  Otherwise the expressions will fail on first names like Mary Jane.

<div>
Take a look at my sample database on splitting and concatenating name and address data:<br />
<a href="http://www.helenfeddema.com/Files/code37.zip" rel="ugc">http://www.helenfeddema.com/Files/code37.zip</a>
</div>


Take a look at my sample database on splitting and concatenating name and address data:
http://www.helenfeddema.com/Files/code37.zip [http://www.helenfeddema.com/Files/code37.zip]

<div>
And if you have some Hispanic or Arabic names in the table, all bets are off!
</div>


And if you have some Hispanic or Arabic names in the table, all bets are off!

<div>
<div class="content wysiwyg-content">
I have received a table with a Name column which contains the 1st and 2nd name<br />
<br />
How can I seperate them into 2 coulums <br />
<br />
1st Name<br />
2nd Name<br />
<br />
I assume its soem sort of left and right function.<br />

</div>
</div>


I have received a table with a Name column which contains the 1st and 2nd name

How can I seperate them into 2 coulums 

1st Name
2nd Name

I assume its soem sort of left and right function.


Seperate a Full Name into 1st and Second

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.