[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 86
  • Last Modified:

Query question

Hi Experts,
I have a query question.  I have a table for Team,  the table only has one field and it's text field.  it stores "00", "PD", "IS", "SU" these four teams.  I would like to create a query for the drop down, but I need combine "00" and "PD" as one name call "DC", so the drop down only shows "DC", "IS" ,"SU".  I tried to used DC: IIf([TEAM]="00" or [TEAM]="PD"),"DC")  IS: IIf([Team]="IS","IS")  SU: IIF([Team]="SU","SU")   but it did not give me the list, what I did wrong?

Thanks
0
urjudo
Asked:
urjudo
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try this query as the rowsource of your dropdown list

select iif([Team] In("00","PD"),"DC",[Team]) From  NameofTable

or

select iif([Team]="00" Or [Team]="PD","DC",[Team]) From  NameofTable
0
 
urjudoAuthor Commented:
I tried in the query, it gave me this result

Expr1
DC
IS
DC
SU
shows DC twice instead once
0
 
urjudoAuthor Commented:
got it, I group it.

Thanks & sorry
0
 
urjudoAuthor Commented:
Thanks!!!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now