Error message when you use the CDec() function in an Access query: "The expression you entered has a function containing the wrong number of arguments"

1. Create a new module and type the following code:

   Function NewCDec(MyVal)
      NewCDec = CDec(MyVal)
   End Function
   					

2. Save and close the module.
3. 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.

Back to the top

Steps to Reproduce Behavior

Office Access 2002 and Office Access 2003

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.

Office Access 2007 and Office Access 2010

1. Create a new database.
2. Create a new table with the following fields:
   Collapse this tableExpand this table

   Name	Data Type	Field Size
   ID	AutoNumber	Long Integer
   MyNum	Number	Double

3. Save the table as Table1.
4. Open the table to add data and enter 10.55 in the MyNum column.
5. Close Table1.
6. Create a new query in Query Design.
7. Select Table1 in the Show Table window and click Add.
8. Click Close to close the Show Table window.
9. Drag the myNum field from the Field List box at the top of the design screen to the Field row of the first column of the query design grid.
10. In the Field row in the second column type: MyNewNum: CDec(myNum)
11. Try to move to the next column in the query design grid. Note that you receive the error message mentioned in the "Symptoms" section.

Back to the top