[AccessD] Wrong number of arguments

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed Apr 9 11:34:59 CDT 2008


Checked the data and there are no nulls.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Wednesday, April 09, 2008 11:20 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Wrong number of arguments

What happens if SumOf3mo_rbi is Null?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, April 09, 2008 9:02 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Wrong number of arguments

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list