Dear Excel experts,

I am struggling with calculations extracted from Access database with
Excel VBA. Is it possible to use custom function with SQL statement?

A normal SQL statement will be like;
SELECT A,B from C

Can I do the following with Excel VBA like;
SELECT function(A,B) from C

I have tried it but failed. I am not sure if this is because this
cannot be done in Excel or I didn't know the right way to do it.

Thank you very much in advance.