How to run a self-write function in an access query?
Posted on 2012-03-18
Dear all experts,
I write a function in access and place it in module, let say:
fx_ReturnNumber (strTemp as string) as string
Dim strTemp2 as string
strTemp2 = strTemp & " - Hello World"
fx_ReturnNumber = strTemp2
If I can bind about function to my query, the result of the query will look like that
ABC - Hello World
CDE - Hello World
EEF - Hello World
XZX - Hello World
I've some query and want to use this function but I cannot include it, does anyone tell me how to accomplish this? Thanks in advance.