[AccessD] why isn't this working?

pedro at plex.nl pedro at plex.nl
Thu Nov 6 12:24:51 CST 2003


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',[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;


More information about the AccessD mailing list