what wrong with iif funtion ?

[hvsummer]

Hi guy, I come back with new issue
I have a code like this

Iif(           
    len([a])>2,  [a]& iif( 
                          len([b])>2,  ”, “&[b]& iif(
                                                    len([c])>2,                ” ,”&[c]
                                                     ,“”
                                                     )
                                    ,iif( 
                                         len([c])>2, “, “&[c]
                                                   , “”
                                         ) 
                          )
              ,iif(
                    len([b])>2,  [b]& iif(
                                          len([c])>2, ” ,”&[c]
                                                    ,“”
                                          )
                              ,iif(
                                   len([c])>2, [c]
                                             ,“.”
                                   ) 
                   )
)
 

when I use this in access, in expression, It showed up error "the expression you entered has a function containing wrong number of arguments"

Any idea :-? help me, thankyou :D

[Seth Schrock]

Nothing jumps out at me. Try removing all of your nested IIF()s and just start back with just the first one, replacing the IIF with some static text to show which path (true or false) the result came from. If the first one works, then add another one. Keep going through this pattern until you figure out what breaks it.

[hvsummer]

I find out that the "" make this problem =.=
since I type code in word to mark code by color, then copy into access. When I remove those "" and replace by typing it againt, it did work... weird case...

[Rabbit]

Some word processors will change the standard double quotes found on the keyboard to a stylized version that is technically a different character.

[NeoPa]

HVSummer:
... since I type code in Word to mark code by color, then copy into access.

Never do that. Never trust Word to do your code in. Not VBA. Not SQL. It will usually muck it up for you because that's not a job it's designed to do. It's designed as a Word Processor.

Find yourself a Text Editor to use if you need to work outside of the natural environment (VBA IDE or SSMS for T-SQL). TextPad and Notepad++ are both good but as long as you find one that works for you then whichever is fine.

Whatever you do though, never use Word or any other Word Processor for developing code.

[dcpking]

As others have said, NEVER use a word processor to code! Use Notepad++ or (my preference) UltraEdit. Your word processor is probably entering the hex string E2 80 9C for your quote marks, instead of the hex character 22. At least, that's what I get in UltraEdit from scraping your code and also from checking out Libre Office Write.

BTW, there doesn't seem to be anything syntactically incorrect with your code :)


Good Luck

Mike