IIF Conditional Statement

Tony

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?

Nov 13 '05 #1

Subscribe Post Reply

1722

PC Datasheet

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
re******@pcdatasheet.com
www.pcdatasheet.com
"Tony" <an**************@gmail.com> wrote in message
news:4c**************************@posting.google.c om...

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?

Nov 13 '05 #2

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

Nov 13 '05 #3

Trevor Best

Tony wrote:

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?

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

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

--
This sig left intentionally blank

Nov 13 '05 #4

by: neblackcat | last post by:

Would anyone like to comment on the following idea? I was just going to offer it as a new PEP until it was suggested that I post it here for comment & consideration against PEP 308. I'm far...

Python

ASP / SQL Query - Conditional SELECT Statement

by: Guy Hocking | last post by:

Hi there, I have a problem in my ASP/SQL Server application i am developing, i hope you guys can help. I have a ASP form with list boxes populated by SQL tables. When a user selects a value...

ASP / Active Server Pages

VS.NET question: conditional run

by: in | last post by:

In Visual Studio, is there a way of marking a statement as a "conditional run". Sort of like a breakpoint, but there, in the debugger, the statement will not execute. I'm thinking of code...

.NET Framework

Access/VBA Conditional Statement

by: Shaldaman | last post by:

I have an Access form called "Login". "Command10" is a button on the form and "Text5" is a text field on it. When a user enters a value in the Text5 text field and clicks the button Command10, I...

Microsoft Access / VBA

Quirk in Conditional Operator?:

by: mux | last post by:

Hi I found out that the following piece of code throws an error. 1 #include "stdio.h" 2 3 int main() 4 { 5 int a,b; 6 a= 10;

C / C++

The conditional operator (?:) and performance.

by: Marty | last post by:

Hi, Does using the the conditional operator (?:) instead of the common "if" statement will give a performance gain in a C# .NET 2003 application (even in C# .NET 2005?). What is the advantage...

C# / C Sharp

Strange operands to conditional operator

by: paulo | last post by:

Can anyone please tell me how the C language interprets the following code: #include <stdio.h> int main(void) { int a = 1; int b = 10; int x = 3;

C / C++

print 1 to n without any conditional statement, loop or jump.

by: dev_cool | last post by:

Hello friends, I'm a beginner in C programming. One of my friends asked me to write a program in C.The purpose of the program is print 1 to n without any conditional statement, loop or jump. ...

C / C++

python syntax for conditional is unfortunate

by: Neal Becker | last post by:

In hindsight, I am disappointed with the choice of conditional syntax. I know it's too late to change. The problem is y = some thing or other if x else something_else When scanning this my...

Python

Conditional Having Statement

by: tiptap | last post by:

Hey Guys, I have a huge statement loads of if statements in... and its getting bigger. On closer inspection there is only 3 difference in the select statement. so I thought I could cut the...

Microsoft SQL Server

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics