Merge criteria in query for display in combo box

[janerussel]

Want to use combo box for selecting criteria to print on report.&nbsp;&nbsp;Report prints employee list for a selected office, ie.,&nbsp;&nbsp;Ohio, Cleveland, San Francisco, Oakland, New York.&nbsp;&nbsp;But, I would like the underlying query to combine San Francisco and Oakland so combo box would display Bay Area Offices and report should print SF and Oakland together if Bay Area is selected from combo box.<br><br>How should I set up query?

 

[gol4]

on Query<br>Area:IIF([city] = &quot;Oakland&quot; or [City] = &quot;San Fransico&quot;,&quot;Bay area&quot;,[City])<br><br>on report<br>IIF([Area] = &quot;Bay area&quot;,&quot;Oakland/San Fransico&quot;,[City])<br>