How to apply self-defined function in Query Design Mode?

[rfan]

I want to extract the integer part of a string data as a single field.
How to apply self-defined function in Query Design Mode?

any hint is appreciated, thank you in advance~

 

[WayneRyan]

rfan,

Add a new column to your query:

NewClm: YourFunction([YourStringField])

Then, put your Public Function in a module.

Wayne