Can I place a function call withing SQL Statements?

Dear Excel/ VBA Expert

I am trying to import data from an MS Access database into my Excel Sheet.
Usually I have no problems with this process but today I need a VBA function in the SQL statement (I know I can do this with nested IIF()s but I want to know how to do this for future reference)

I have written the SQL statement in MS Excel
I have written the VBA function in MS Access because that is where the SQL is processed. Is my understanding correct in this regard?

ASIDE: Please comment on this.
(I just got an idea of doing this.... perhaps I can run a VBA function from within Access that has the SQL statement because I know it works in MS Access(I tested the below just in Access (not running the intial SQL in Excel)). However, why doesn't this work from within Excel?

'******The error Message is attached thanks.

' CODE IN MS Excel. Importing Data from access

Please Login or Register  to view this content.

Your Help is much Appreciated.