Add OR IIF to my statement

From: Jon Dibble <Jon Dibble@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 10 Sep 2009 04:49:01 -0700

Hi
Can anyone please help me add to my statement?

Currently it returns text based on data in a string field on our database.

What I need to add is that if other strings like "7701" or "8901" appear in
the database field then return other text I specify.

Expr2: IIf([dbo_customer]![SALESMAN]="2501","Tracey","No Rep")

Any help would be greatly appreciated.
.

Follow-Ups:
- Re: Add OR IIF to my statement
  - From: Ken Snell [MVP]

Prev by Date: Re: How to Exclude result from one query from another
Next by Date: Date Criteria Range
Previous by thread: query with conditions
Next by thread: Re: Add OR IIF to my statement
Index(es):
- Date
- Thread