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
urjudoAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.