[AccessD] why isn't this working?

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

Pedro 


In antwoord op:

> From: Gustav Brock <gustav at cactus.dk>
> To: Access Developers discussion and problem solving
> Date: Fri, 7 Nov 2003 14:06:55 +0100
> Subject: Re: [AccessD] why isn't this working?
> 
> 
> 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?
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.