<div>
Perfect solution. &nbsp;Thanks.
</div>


<div>
<div class="content wysiwyg-content">
I have this syntaxin a query designer field but need to get rid of the 2nd comma if there is no data in the field &quot;Address2)<br />
<br />
Street Address: [Address1] &amp;&nbsp;IIf([Address2]=&quot;&quot;,&quot;&quot;,&quot;, &quot;&nbsp;&amp; [Address2])<br />
<br />
Right as it stands I get, for example, <br />
<br />
1234 West Circle Drive, <br />
<br />
but want to get just<br />
<br />
1234 West Circle Drive &nbsp;(no comma)<br />
<br />
<br />
What is wrong with my syntax?<br />
<br />
--Steve
</div>
</div>


I have this syntaxin a query designer field but need to get rid of the 2nd comma if there is no data in the field "Address2)

Street Address: [Address1] & IIf([Address2]="","",", " & [Address2])

Right as it stands I get, for example, 

1234 West Circle Drive, 

but want to get just

1234 West Circle Drive  (no comma)


What is wrong with my syntax?

--Steve

How get rid of second comma in a concatenated field if there is no data in the 2nd field

I have this syntaxin a query designer field but need to get rid of the 2nd comma if there is no data in the field &quot;Address2)

Street Address: [Address1] &amp; IIf([Address2]=&quot;&quot;,&quot;&quot;,&quot;, &quot; &amp; [Address2])

Right as it stands I get, for example, 

1234 West Circle Drive, 

but want to get just

1234 West Circle Drive  (no comma)


What is wrong with my syntax?

--Steve

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.