Calling VBA Functions from Access SQL

Question

How is this done ? How must the function be written and how does SQL recognize the function ?

Answer 1

Hi

You just write the function as a normal vba function and then use it as any other function eg sum() as Access will auto-recognise and call it.

so

Function Multiply(val1 int, val2 int) as long

Multiply = Val1*Val2

End Function



can be used as

select Multiply(col1,col2) from mytable or within the design view in the select part.