[AccessD] why isn't this working?

I could't believe that is was the query that made the #Error. So i tested a little further. The real course of the #error are the quote's (') before and after the nummer. When deleting them everything works fine.

Thanks

Pedro Janssen





In antwoord op:

> From: pedro at plex.nl
> To: AccessD at databaseadvisors.com
> Date: Fri, 07 Nov 2003 15:21:50 (MET)
> Subject: Re: [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.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>