[AccessD] why isn't this working?

On 6 Nov 2003 at 12:24, pedro at plex.nl wrote:

> Hello Group,
> 
> i can't seem to let this query work. Why?
> 
> Pedro Janssen
> 
> 
> SELECT
> iif([Code]='501',[Telling]*1),iif([Code]='503',[Telling]*2),iif([Code]=
> '507',[Telling]*2),iif([Code]='506',[Telling]*0,67),iif([Code]='502',[T
> elling]*0,4),iif([Code]='522',[Telling]*0,4),iif([Code]='542',[Telling]
> *0,2),iif([Code]='500',[Telling]*0) AS Resultaat_Telling FROM
> TellingCode; 

All the closing brackets are in the wrong places, They should be at 
the end of the last iif().

i.e. It should be something like:

IIF(a,z,IIF(b,y,IIF(c,x,IIF(d,w,v))))



 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.