<div>
so my response needs correction too ... just assumed you were your usual amazing self, Pat ~
</div>


<div>
:)<br />
I was distracted by a phone call and just quickly sent. &nbsp;Sometimes work gets in the way.
</div>


<div>
As you for sure have some addresses without a dot, this will be a safer method:<br />
<br />
&nbsp; &nbsp; EmailName: Replace(Left([emailaddress<wbr />], InStr([emailaddress],&quot;@&quot;)-<wbr />1),&quot;.&quot;,&quot; &quot;)<br />
<br />
/gustav
</div>


<div>
good point, gustav ... &nbsp;your equation should be TRIMmed too -- not that it really matters though<br />
<br />
I so much prefer writing functions since they are more clear, especially when equations get long!
</div>


<div>
I still can't get the last name to work correctly. &nbsp;Are you sure that is correct?
</div>


<div>
Actually got it! &nbsp;There was a comma missing...Here was the final code: <br />

<pre><code class="code-1 nolinks" id="code-20-41791887-1"><span>Last: Mid([supervisor1email],InStr([supervisor1email],&quot;.&quot;)+1,InStr([supervisor1email],&quot;@&quot;)-InStr([supervisor1email],&quot;.&quot;)-1)</span>
</code></pre>
</div>


<div>
what is the original string before @ and what do you get?
</div>


<div>
you're welcome ~ happy to help
</div>


<div>
<div class="content wysiwyg-content">
I have a field that is an email address. &nbsp;This address always follows the format of &quot;john.smith@gmail.com&quot;. &nbsp;The names are not always the same length. &nbsp;I would like the output to read &quot;john smith&quot;. &nbsp;Any help with this would be appreciated!
</div>
</div>


I have a field that is an email address.  This address always follows the format of "john.smith@gmail.com".  The names are not always the same length.  I would like the output to read "john smith".  Any help with this would be appreciated!

How can I split a string into 2 parts in a Microsoft Access Query

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.