Syntax error (comma) in query expression?

[TheWolfster]

Hello again!



I'm trying to write a IIF function, but I keep getting this error. Have I set it up wrong?

Negative behavior: IIf([T1_HAngerTotNoInt]="1", "1", IIf([T1_HDisgtTotNoInt]="1", "1", IIf([T1_HCntmpTotNoInt]="1", "1", IIf([T1_HWhineTotNoInt]="1", "1", IIf([T1_HSadnsTotNoInt]="1", "1", IIf([T1_HFerTotNoInt]="1", "1", IIf([T1_HDominTotNoInt]="1", "1", IIf([T1_HBeligTotNoInt]="1", "1", IIf([T1_HDefenTotNoInt]="1", "1", "0")))))))))

The raw data is only 1's and 0's.

The full error:



(its physiology data if you're curious)

Thanks if anyone can help! I'm still a novice

Edit: Ohhh, they're supposed to be separate fields...do I have to split up the IIF statement into 9 parts?

Edit2: Even individual IIF's don't work. Hmm...

[pbaldy]

I'm not sure how many IIf() functions you can nest, but you might want to check out the Switch() function. I think it will be a lot simpler.

[TheWolfster]

Yeah, I'm thinking there might a limit, but setting up just 1 IIF statement gives me the same error.

How would Switch() work? Wouldn't that take a number and give it a value (1=A, 2=B) -- just setting TRUE but noth both? I think IIF is perfect for me. (Unless I'm wrong? I don't know too much about Access).

But thanks for the reply, somehow I feel less anxious :P

[TheWolfster]

Negative behavior: IIf([T1_HAngerTotNoInt]="1",1,IIf([T1_HDisgtTotNoInt]="1",1,IIf([T1_HCntmpTotNoInt]="1",1,IIf([T1_HWhineTotNoInt]="1",1,IIf([T1_HSadnsTotNoInt]="1",1,IIf([T1_HFerTnTotNoInt]="1",1,IIf([T1_HDominTotNoInt]="1",1,IIf([T1_HBeligTotNoInt]="1",1,IIf([T1_HDefenTotNoInt]="1",1,0)))))))))

Hmm, I rewrote it as follows, and now it works?



Edit: Sorry, double post!

[pbaldy]

I'm glad you got it working, but Switch() would have been simpler. The example from Help:

Switch(CityName = "London", "English", CityName = "Rome", "Italian", CityName = "Paris", "French")

[TheWolfster]

I'll try that, thanks!

Guess its okay to mark this as solved?