[AccessD] why isn't this working?

Hi Pedro

Perhaps Code is a number and not a string?
If so:
  IIf([Code]=542 ...

Or Telling is a string?

Try:

    SELECT
      [Code]='542' AS CodeTest,
      [Telling]*0.2 AS TellingTest
    FROM
      TellingCode;

/gustav


> Hello Gustav,

> When i used your minimum expression, there was a querytable in the
> View, but in the records was standing #Error. 
> The trouble is that TellingCode is a query. When i made a
> MakeTableQuery first from TellingCode and did the expression from
> tblTellingCode it was working. Why isn't the expression working on a
> query??

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