Multiple IIf statements 1

[Tronsliver]

I'm trying to insert multiple IIf statements in a query but keep getting an error message. I'm in query design mode and trying to insert the expression in the "field" slot. Here is an example:

mileducation: IIf([sidstrHI_MIL_COL_CR_COMPL]="A1","2"," &quot,IIf([sidstrHI_MIL_COL_CR_COMPL]="A0","1"," &quot

When I try to save it I get a syntext error.

Thank you for the help,

Roger

 

[tlbroadbent]

Here are some corrections.

mileducation: IIf([sidstrHI_MIL_COL_CR_COMPL]="A1","2",IIf([sidstrHI_MIL_COL_CR_COMPL]="A0","1"," &quot)

This equates to

If [sidstrHI_MIL_COL_CR_COMPL]="A1" Then
mileducation = "2"
ElseIf [sidstrHI_MIL_COL_CR_COMPL]="A0" Then
mileducation = "1"
Else
mileducation = " "
End If Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[Quehay]

You might be able to use the switch function here. Check the examples in help. How many possible values are there for this field and do you want to explicitly handle only the two values you've shown here? If so, it will probably do the trick.

Also: Do you want to insert a zero-length string or a single space? (it looks like the latter but that could be the web page)

 

[tlbroadbent]

Quehay,

Good suggestion. Switch is usually easier to understand when the selection list becomes long.

Thanks, Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm