pedro at plex.nl
pedro at plex.nl
Fri Nov 7 13:48:02 CST 2003
Hello Gustav, Jim and others, i tried your solution, and also changed comma's to points as Jim suggested, but i still get an error: Wrong number of arguments used with function ?????? What could be the problem know? Pedro 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; _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com