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:
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:
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?