<div>
I think that the problem is not in Access version but in the data. I suppose that the problem arises when Email doesn't contain # (or did you mean @?)<br />
<br />
Try to modify this way<br />
<br />
Email2: IIf([Email]&lt;&gt;&quot;&quot; and InStr(1,[Email],&quot;#&quot;)&gt;1,Lef<wbr />t([Email],<wbr />InStr(1,[E<wbr />mail],&quot;#&quot;)<wbr />-1),&quot;&quot;)
</div>


<div>
Spot on, i forgot that i refrence outlook and use novell at work.<br />
<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
Can anyone help to solve this issue, works in Access 2007, fails in Acccess 2003.<br />
<br />
Email2: IIf([Email]&lt;&gt;&quot;&quot;,Left([Emai<wbr />l],InStr(1<wbr />,[Email],&quot;<wbr />#&quot;)-1),&quot;&quot;)<wbr /><br />
<br />
Thanks
</div>
</div>


Can anyone help to solve this issue, works in Access 2007, fails in Acccess 2003.

Email2: IIf([Email]<>"",Left([Email],InStr(1,[Email],"#")-1),"")

Thanks

I think that the problem is not in Access version but in the data. I suppose that the problem arises when Email doesn&#39;t contain # (or did you mean @?)

Try to modify this way

Email2: IIf([Email]&lt;&gt;&quot;&quot; and InStr(1,[Email],&quot;#&quot;)&gt;1,Left([Email],InStr(1,[Email],&quot;#&quot;)-1),&quot;&quot;)

Spot on, i forgot that i refrence outlook and use novell at work.

Thanks

Undefined Left In Expression

Can anyone help to solve this issue, works in Access 2007, fails in Acccess 2003.

Email2: IIf([Email]&lt;&gt;&quot;&quot;,Left([Email],InStr(1,[Email],&quot;#&quot;)-1),&quot;&quot;)

Thanks

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.