[AccessD] why isn't this working?

Hi Pedro

It should probably read:

iif([Code]='501',[Telling]*1,iif([Code]='503',[Telling]*2,iif([Code]='507',[Telling]*2,iif([Code]='506',[Telling]*0,67,iif([Code]='502',[Telling]*0,4,iif([Code]='522',[Telling]*0,4,iif([Code]='542',[Telling]*0,2,iif([Code]='500',[Telling]*0,0))))))))

/gustav

> 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',[Telling]*0,4),iif([Code]='522',[Telling]*0,4),iif([Code]='542',[Telling]*0,2),iif([Code]='500',[Telling]*0)
> AS Resultaat_Telling
> FROM TellingCode;