Share via

Cannot Open Query - Error Message Function contraining the wrong number of arguments

Anonymous
2014-05-21T20:51:48+00:00

Hello,

I have a query in Access. The query was originally build in Access 2000 but I have sense then upgraded to 2013.  When I try to open the query, I get an error message, "The expression you entered has a function containing the wrong number of arguments."  When I click OK on the message box, the query closes. Therefore, I can check the query to find out what is wrong. I've tried opening it in design view and I get the same results.  How does one get beyond the error message so that the function can be corrected.

Thanks

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-05-21T23:17:29+00:00

    You could print the SQL statement of the query in the debug window (aka immediate window) with:

    ? CurrentDb.QueryDefs("YourQueryNameGoesHere").SQL

    You can then correct this and create a new query by pasting the amended SQL statement into the query designer in SQL view.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2014-05-29T14:58:57+00:00

    Thanks Ken, I got busy on something else and haven't had a chance to try this but I will and will let you know if that works. I'm sure that it will though. You guys almost always have the answers I need. You guys rock!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-05-21T20:52:51+00:00

    Sorry, that should be, ... Therefore I cannot check the query to find out what is wrong.

    Was this answer helpful?

    0 comments