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;