select MyFuction(id) as Mydata from datatable
^^^^^^^^^
其中MyFuction是一个自定义函数,放在access的模块里
fuction MyFuction(ss as string) as string
select case ss
case = "case1"
......
MyFuction=....
case = "case2"
......
MyFuction=....
case = "case2"
....
MyFuction=....
end select
end function
如果在vb中用
select MyFuction(id) as Mydata from datatable则不行,