Microsoft KB Archive/225931

= ACC2000: "Wrong Number of Arguments" Error When You Use CDec Function in a Query =

Article ID: 225931

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q225931





Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you use the CDec function in a Microsoft Access query, you may receive the following error message:

The expression you entered has a function containing the wrong number of arguments.



CAUSE
The CDec function is supported in Visual Basic for Applications code, but not in Access queries.



RESOLUTION
Create a custom function that uses the CDec function. Call this custom function from your Access query. For example:

  Create a new module and type the following code: Function NewCDec(MyVal) NewCDec = CDec(MyVal) End Function  Save and close the module. Type MyID: NewCDec([CategoryID]) in the Field row of a query. Note that when you run this function, it returns a valid value for the MyID field.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) In the Database window, click Queries under Objects, and then click New.
 * 3) In the New Query box, click Design View, and then click OK.
 * 4) In the Show Table box, click the Categories table. Click Add, and then click Close.
 * 5) Drag the CategoryName field from the Field List box to the Field row of the first column of the query design grid.
 * 6) Type MyID: CDec(CategoryID) in the Field row of the second column.
 * 7) Try to move to the next column in the query design grid. Note that you receive the error message mentioned in the "Symptoms" section.

Additional query words: pra recognized

Keywords: kbbug kbnofix KB225931

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.