iff Fuction question

  • Thread starter Thread starter Dennis Villareal
  • Start date Start date
D

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
 
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




kev100 via AccessMonster.com said:
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


Dennis said:
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
Click to expand...
Click to expand...
 
still not working with

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


kev100 via AccessMonster.com said:
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.
Click to expand...
[quoted text clipped - 7 lines]
thanks
Click to expand...
Click to expand...
Click to expand...
 
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

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

Dennis Villareal said:
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
Click to expand...
Click to expand...
 
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
Click to expand...

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.
 
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.
 
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.
Click to expand...

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)
 
Back
Top