What I am trying to do is create a page header with a text box,
controlled by this formula:

=IIf([CITY] Like "C"=True,"Calgary","Edmonton")

The field [CITY] can either be a "C" or "E", I know this should be
easy to figure this out but it's taking me tooooo long! Could someone
please help me out with this?

If [City] is specifically either C or E, use this:
=IIf([CITY] = "C","Calgary","Edmonton")

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource (AT) pcdatasheet (DOT) com
www.pcdatasheet.com


"Tony" <anthony.hendrata (AT) gmail (DOT) com> wrote

If you wan to see if the first letter is a C then use this

=IIf([CITY] Like "C*","Calgary","Edmonton")
or

=IIf(left([CITY],1)="C","Calgary","Edmonton")

Good Luck.

Julie

Tony wrote:
IIf([CITY]="C","Calgary","Edmonton")

Or if it's just the first letter:
IIf([CITY] like "C*","Calgary","Edmonton")

--
This sig left intentionally blank