<div>
Left(Last.First,Len(Last.F<wbr />irst,&quot; &quot;)-1)<br />
<br />
Flyster
</div>


Left(Last.First,Len(Last.First," ")-1)

Flyster

<div>
Exmaple<br />
<br />
Left(&quot;joe, jammer&quot;,Instr(1, &quot;Joe, Jammer&quot;,&quot; &quot;)-1)<br />
<br />
returns<br />
<br />
joe,<br />
<br />
including the comma.<br />
<br />
mx
</div>


Exmaple

Left("joe, jammer",Instr(1, "Joe, Jammer"," ")-1)

returns

joe,

including the comma.

mx

<div>
DatabaseMX is correct. I meant to use Instr instead of Len.<br />
Left([Last.First],InStr([L<wbr />ast.First]<wbr />,&quot; &quot;)-1)<br />
<br />
If you don't want the comma to show, change the -1 to -2.
</div>


DatabaseMX is correct. I meant to use Instr instead of Len.
Left([Last.First],InStr([Last.First]," ")-1)

If you don't want the comma to show, change the -1 to -2.

<div>
<div class="content wysiwyg-content">
I have a field formatted like the following:<br />
<br />
last.first (last, first mi)<br />
<br />
I need to get just the last.first portion (everything before the first space). &nbsp;<br />
<br />
What's best way to do this?<br />
<br />
Thanks,<br />
Matt
</div>
</div>


I have a field formatted like the following:

last.first (last, first mi)

I need to get just the last.first portion (everything before the first space).  

What's best way to do this?

Thanks,
Matt

Get text before space in access

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.