IIf Function with multiple Conditions

[ice051505]

Hi all, I have a query with 5 field, [Country],[Province],[GroupingInfo],[City],[Area]
I want to write or build a new query to have something on the [City] critiria like:

IIf [City]="NoInfo" And [GroupingInfo]<=1 Then [City]=[Province], else [City] = [City]

This is on the Query Sql, not on the VBA Code

Thanks So Much!

 

[djj55]

CITY = CASE WHEN  [City]="NoInfo" And [GroupingInfo]<=1 Then [Province] else [City] END

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!