Executing Access Query that uses a VB function

[NN]

Hi!
I have written a query inside Access that uses an Access VB Module public function. I use it to do some conditional processing. Although the query works fine through Access, VB reports an "Undefined Function" error
when I try to execute the query using the
db.Execute "MyQuery"
syntax.

Can someone please help me?

Is it that I cant use Access defined VB functions within
queries executed in VB?

[NN]

Well I just found out that Userdefiend functions can only be
used within Access queries and not within VB executed quries!

Thanks to anyone who thought of replying!