<div>
<br />
try this<br />
<br />
Group1: Left$([Group] &amp;&nbsp;&quot; &quot;,InStr(1,[Group],&quot; &quot;)-1)
</div>



try this

Group1: Left$([Group] & " ",InStr(1,[Group]," ")-1)

<div>
Still getting #ERROR for the fields that have one word.
</div>


Still getting #ERROR for the fields that have one word.

<div>
That did it. &nbsp;I was about to say that I am importing from an Excel spreadsheet so the space might have some sort of funny format.<br />
<br />
Thanks.
</div>


That did it.  I was about to say that I am importing from an Excel spreadsheet so the space might have some sort of funny format.

Thanks.

<div>
<div class="content wysiwyg-content">
I have a field which somtimes includes two words and I only need the first word. &nbsp;I can use this to show only the first word: <br />
Group1: Left$([Group],InStr(1,[Gro<wbr />up],&quot; &quot;)-1)<br />
But when I use it I get #ERROR for all of the fields that only have one word. &nbsp;How do identify the field has one or two words so I can skip if it only has one word? <br />
<br />
Thanks.
</div>
</div>


I have a field which somtimes includes two words and I only need the first word.  I can use this to show only the first word: 
Group1: Left$([Group],InStr(1,[Group]," ")-1)
But when I use it I get #ERROR for all of the fields that only have one word.  How do identify the field has one or two words so I can skip if it only has one word? 

Thanks.

Identifyng one word or two in a field

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.