Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can function be used within SQL statement?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function or If statement help | Excel Worksheet Functions | |||
IF function returns function statement rather than result | Excel Worksheet Functions | |||
IF Then statement or another function to look for a value | Excel Worksheet Functions | |||
Function IF statement | Excel Worksheet Functions | |||
MAX function with IF Statement | Excel Programming |