MSQuery: Can't Use Views with User-Defined Functions |
The information in this article applies to:
- Microsoft Query for Windows, version 1.0
SUMMARY
When you use a Microsoft Access data source in Microsoft Query, you receive the following error message when you add a view from the Add Tables dialog box to the Table pane
Undefined function '<function name>' in expression
where <function name> is the name of a custom function you defined.
MORE INFORMATION
In Microsoft Access, you can define a custom (user-defined) function that takes one or more arguments and returns a result that can be used in an expression, such as a SELECT statement. In Microsoft Query, a Microsoft Access query is called a "View," and it returns a result set in a tabular format. A view can be selected from the Add Tables dialog box and added to the Data pane. If the view is based on a SELECT statement containing a user- defined function, the error message in the "Summary" section of this article will be displayed.
REFERENCES
For more information on working with views, click the Search button in Help and type views or "Table Options Dialog Box."
Additional query words: 2.00
Keywords : xlquery
Version : WINDOWS:1.0
Platform : WINDOWS
Issue type :
Technology :
Last Reviewed: November 3, 1999 |