<div>
are there any characters that separates the two fields (ie. &quot;,&quot;) ?<br />
anyway the sql statement may look like this<br />
<br />
Update MyTable set FirstName = Mid([FirstNameandSurname],<wbr />1,8),<br />
LastName = Mid([FirstNameandSurname],<wbr />9,20) <br />
<br />
<br />
....this assumes that the first 8 char is the first name and and the<br />
rest is the surname
</div>


are there any characters that separates the two fields (ie. ",") ?
anyway the sql statement may look like this

Update MyTable set FirstName = Mid([FirstNameandSurname],1,8),
LastName = Mid([FirstNameandSurname],9,20)


....this assumes that the first 8 char is the first name and and the
rest is the surname

<div>
paasky's answer was correct, it worked and it was first.<br />
<br />
Many thanks.<br />
<br />
robinski
</div>


paasky's answer was correct, it worked and it was first.

Many thanks.

robinski

<div>
Happy to help you robinski.<br />
<br />
Best regards,<br />
Paasky
</div>


Happy to help you robinski.

Best regards,
Paasky

<div>
<div class="content wysiwyg-content">
Greetings To All<br />
============<br />
<br />
First my apology - I've asked before, used the answer and now I've<br />
lost it.<br />
<br />
I have a field [FirstNameandSurname] in an imported table.<br />
<br />
I need to store [FirstName] and [Surname] separately.<br />
<br />
Your advice will be saved somewhere safe this time.<br />
<br />
Many thanks,<br />
<br />
Robinski<br />

</div>
</div>


Greetings To All
============

First my apology - I've asked before, used the answer and now I've
lost it.

I have a field [FirstNameandSurname] in an imported table.

I need to store [FirstName] and [Surname] separately.

Your advice will be saved somewhere safe this time.

Many thanks,

Robinski


Extract FirstName and Surname from Name

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.