从Where子句调用UDF的数据不匹配 [英] Data Mismatch for UDF called from Where clause

问题描述

你好，


我开始研究VBA，从昨天开始访问，在这里我遇到了第一个问题:)。请帮忙。


当我的UDF返回一个整数时，我得到上述问题。（以下是UDF）：

****** ********************************************

展开 | 选择 | Wrap | 行号

解决方案

抱歉忘记提及，我只需要选择那些具有M的记录。在缺失数据汇总表的Field40中。我已经编写了这个复杂的逻辑，因为我需要进一步修改它，以便UDF的返回值将从包含field40的记录中30个字段的值的逻辑派生。谢谢!!

尝试：

展开 | 选择 | Wrap | 行号

@OldBirdman


@OldBirdman


非常感谢您的快速回复。不匹配消失但我现在得到一个Unknown Jet错误。我不知道那是什么，所以一旦我知道就会回来。感谢

Hello,

I started working on VBA,access from yesterday, and here I am with my first problem :). Please help.

I get the above mentioned problem when my UDF is returning an integer.(Following is the UDF):
**************************************************

Expand|Select|Wrap|Line Numbers

解决方案

Sorry Forgot to mention,I need only those records to be selected which have a "M" in Field40 of Missing data summary table. I have written this complex logic as I need to further modify it such that the return value from the UDF will be derived from a logic on values of 30 fields in the record including field40. Thanks!!

Try:

Expand|Select|Wrap|Line Numbers

@OldBirdman
@OldBirdman

Thank you so much for the prompt reply. The mismatch is gone but I get an Unknown Jet error now. I do not know what that is,so will get back once i know. Thanks

这篇关于从Where子句调用UDF的数据不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！