Can function be used within SQL statement?

  • Thread starter Thread starter Roth
  • Start date Start date
R

Roth

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.
 
th efunction must include a database name where the macro is located.

db1.mdb!function(a,b)
 
SELECT GetCoupon([Security]) FROM BondTables

raised an "Undefined Function" error in Excel,. In my Access database, its a
public function
 
Back
Top