Kaup, Chester
Chester_Kaup at kindermorgan.com
Wed Apr 9 13:32:56 CDT 2008
Here is the reason it does not work. From Microsoft: The CDec() function is supported in Visual Basic for Applications code, but not in Access queries. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Wednesday, April 09, 2008 12:09 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Wrong number of arguments Usually means that you have mis-spelled the name of one of the arguments and it cannot find it. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Wednesday, April 09, 2008 5:35 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Wrong number of arguments 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 -- 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