Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call UDF In Query
Message
General information
Forum:
Microsoft Office
Category:
Access
Environment versions
Microsoft Office:
Office 2007
Miscellaneous
Thread ID:
01425509
Message ID:
01425515
Views:
17
>>>>I want to call it in a query I'm working on. So in the expression builder I tried:
>>>>
>>>>
>>>>VN-PAID: CleanString([VEN_YTDPaidAmt])
>>>>
>>>>
>>>>I get "Undefined function 'CleanString' in expression".
>>>>
>>>>How do I do this?
>>>
>>>In SQL Server it would be dbo.CleanString([myField])
>>
>>Ok....
>>
>>???
>
>Which builder you're referring here?

The expression builder. I can see my function in the functuion list. It's public. But when I run it, it errors as above. I'm really getting peaved now. This should work,
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Reply
Map
View

Click here to load this message in the networking platform