<div>
Thanks Pat,<br />
<br />
Can you format for the query builder?<br />
Under what field do I input your IIf statement?
</div>


Thanks Pat,

Can you format for the query builder?
Under what field do I input your IIf statement?

<div>
<blockquote>
Can you format for the query builder?<br />
Under what field do I input your IIf statement? 
</blockquote>
Just switch from the query builder mode to SQL mode (first icon in the ribbon), copy / paste the query and switch back to query builder mode.
</div>


> Can you format for the query builder?
> Under what field do I input your IIf statement?

Just switch from the query builder mode to SQL mode (first icon in the ribbon), copy / paste the query and switch back to query builder mode.

<div>
Don't forget to use the correct names for the columns. &nbsp;Just eliminate the extra fields if you only need the two named ones.
</div>


Don't forget to use the correct names for the columns.  Just eliminate the extra fields if you only need the two named ones.

<div>
<div class="content wysiwyg-content">
How can I add text to my drop down query to add &quot;Compl&quot; to the project Name if Status is Completed?<br />
<br />
In my query design:<br />
Table: <br />
Projects<br />
Fields:<br />
Project Name <br />
Status<br />
<br />
Projects have a status of &quot;working&quot; or &quot;completed&quot;.<br />
If a project has a status of &quot;completed&quot; how can I add &quot;Compl-&quot; to the project name:<br />
Example:<br />
Compl - Replace Shingles on North Side<br />
<br />
My attempt: (added statement in criteria in query design view under the ProjectName field)<br />
IIf([Status]=&quot;Completed&quot;,(<wbr />&amp;&quot;Compl-&quot;&amp;<wbr />[Projects]<wbr />![ProjectN<wbr />ame]),([Pr<wbr />ojects]![P<wbr />rojectName<wbr />]) ) ---not working<br />
<br />
Also, how can I put the projects with &quot;Compl-&quot; in the bottom of the list?
</div>
</div>


How can I add text to my drop down query to add "Compl" to the project Name if Status is Completed?

In my query design:
Table: 
Projects
Fields:
Project Name 
Status

Projects have a status of "working" or "completed".
If a project has a status of "completed" how can I add "Compl-" to the project name:
Example:
Compl - Replace Shingles on North Side

My attempt: (added statement in criteria in query design view under the ProjectName field)
IIf([Status]="Completed",(&"Compl-"&[Projects]![ProjectName]),([Projects]![ProjectName]) ) ---not working

Also, how can I put the projects with "Compl-" in the bottom of the list?

How can I add static text to my drop down project name 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.