[AccessD] Wrong number of arguments

Is the result possibly a Null?  You might try wrapping the results
parameters of the IIF in NZ()  Just a guess.

GK

On Wed, Apr 9, 2008 at 11:02 AM, Kaup, Chester
<Chester_Kaup at kindermorgan.com> wrote:
> I am confused as to why the following field in a query returns the error
>  message of wrong number of arguments. The expression works fine without
>  the CDec. What am I doing wrong?
>
>
>
>  Factor_1:
>  CDec(IIf([SumOf3mo_rbi]=0,[Allocations]![Factor_1],[3mo_rbi]/[SumOf3mo_r
>  bi]))
>
>
>
>  Chester Kaup
>
>  Engineering Technician
>
>  Kinder Morgan CO2 Company, LLP
>
>  Office (432) 688-3797
>
>  FAX (432) 688-3799
>
>
>
>
>
>  No trees were killed in the sending of this message. However a large
>  number of electrons were terribly inconvenienced.
>
>
>
>  --
>  AccessD mailing list
>  AccessD at databaseadvisors.com
>  http://databaseadvisors.com/mailman/listinfo/accessd
>  Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com