iff Fuction question

[Dennis Villareal]

in my query this is what i have in the field.

GC: IIf([GageChange]=Yes,"1")

i would like it to show

if yes show 1 if no show 0

how would i go about that?

thanks

 

[Golfinray]

Or you could do IIF([gagechange]="yes",1," ") for nothing

 

[Dennis Villareal]

ok i am getting some kind of error

Syntax error (comma) in query expression
'IIf([GageChange]=Yes,"1",([GageChange]=No,2))'

this info if being pulled from a database where the Data Type is Yes/No

General Tab

Format - Yes/No
Caption -
Default Value - No
Validation Rule -
Validation Text -
Required - No
Indexed - No

Lookup Tab

Display Control - Combo Box
Row Source Type - Value List
Row Source - ";Yes;No"
Bound Column - 1
Column Count - 1
Column Heads - No
Column Widths -
List Rows - 8
List Width - Auto
Limit to List - No

Are the only 2 possible values for [GageChange] Yes or No ?

If so....the iif statement allows a type of "nested loop/else" function.

It gets a little messy if there are too many possible values....but if all
the syntax is correct...things should work fairly reliably.

Try (assuming only 2 values are possible for GageChange):

IIf([GageChange]=Yes,"1",([GageChange]=No,2))

...note that there are 2 closed parentheses on the end to match the 2 opened
on the left.

If you need a Default value (if GageChange is neither Yes or No).....add the
following:

IIf([GageChange]=Yes,"1",([GageChange]=No,2,default value here))


Give these a try....I'm pretty sure all the syntax is correct.

Thanks

in my query this is what i have in the field.

GC: IIf([GageChange]=Yes,"1")

i would like it to show

if yes show 1 if no show 0

how would i go about that?

thanks

 

[Dennis Villareal]

still not working with

IIf([GageChange]=Yes,"1",([GageChange]=No,"2","default value here"))
IIf([GageChange]=Yes,"1",([GageChange]=No,"2"))

Oops...forgot the needed quotes:


IIf([GageChange]=Yes,"1",([GageChange]=No,"2"))

..or..

IIf([GageChange]=Yes,"1",([GageChange]=No,"2","default value here"))


- kev

Are the only 2 possible values for [GageChange] Yes or No ?

If so....the iif statement allows a type of "nested loop/else" function.

It gets a little messy if there are too many possible values....but if all
the syntax is correct...things should work fairly reliably.

Try (assuming only 2 values are possible for GageChange):

IIf([GageChange]=Yes,"1",([GageChange]=No,2))

...note that there are 2 closed parentheses on the end to match the 2 opened
on the left.

If you need a Default value (if GageChange is neither Yes or No).....add the
following:

IIf([GageChange]=Yes,"1",([GageChange]=No,2,default value here))

Give these a try....I'm pretty sure all the syntax is correct.

Thanks

in my query this is what i have in the field.

[quoted text clipped - 7 lines]

thanks

 

[Dennis Villareal]

thanks had to change it a little to do what i wanted to but you pointed me to
the right location

IIf([gagechange]=Yes,"1","0")

thanks

Or you could do IIF([gagechange]="yes",1," ") for nothing

in my query this is what i have in the field.

GC: IIf([GageChange]=Yes,"1")

i would like it to show

if yes show 1 if no show 0

how would i go about that?

thanks

 

[John W. Vinson]

in my query this is what i have in the field.

GC: IIf([GageChange]=Yes,"1")

i would like it to show

if yes show 1 if no show 0

how would i go about that?

thanks

It's much simpler than you're making it.

Assuming GageChange is a Yes/No field...

IIF([GageChange], 1, 0)

The IIF function has three arguments: an expression which is either TRUE or
FALSE (often of the form A = B but it doesn't matter where the true or false
comes from!); the value to return if TRUE; and the value to return if FALSE.

or even

Abs([GageChange])

This works because a Yes/No field is stored as -1 for True/Yes/Checked, 0 for
False/No/Unchecked.

 

[Ron2006]

Whenever I have done a compound iif test it HAS to have the second iif
stated.

Up till now it has been stated as:
IIf([GageChange]=Yes,"1",([GageChange]=No,"2","default value here"))



Should that not rather be:
IIf([GageChange]=Yes,"1",iif([GageChange]=No,"2","default value
here"))


I get a syntax error when trying it the first way.

 

[John W. Vinson]

Whenever I have done a compound iif test it HAS to have the second iif
stated.

Up till now it has been stated as:
IIf([GageChange]=Yes,"1",([GageChange]=No,"2","default value here"))



Should that not rather be:
IIf([GageChange]=Yes,"1",iif([GageChange]=No,"2","default value
here"))


I get a syntax error when trying it the first way.

I didn't suggest the first way. That was your choice.

If GageChange is a yes/no field then you don't need a second condition. It's
either TRUE (yes) or FALSE (no); you don't even need an equality check, since
the first argument of IIF must be either TRUE (return the second argument) or
FALSE (return the third argument). What do you get if you use

IIF([GageChange], 1, 2)