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?