[AccessD] why isn't this working?

Gustav Brock gustav at cactus.dk
Fri Nov 7 07:06:55 CST 2003


Hi Pedro

You still may have mistyped something.
Try with a minimum expression:

   SELECT
     IIf([Code]='542',[Telling]*0.2,0) AS Resultaat_Telling
   FROM
     TellingCode;

If this doesn't work something else is wrong.
If it works, replace 0 with another IIf() construction and so on.

/gustav


> 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?



More information about the AccessD mailing list