I have an access query which looks something like this:

SELECT batting.player, careerteams(batting.player), stuff
FROM batting
WHERE batting.seg = 0

The careerteams is actually a function within access that returns back all the teams a player ever played for.

When I try to use the query in VB (regardless of where or how), it tells me its an invalid function call.

I've tried copying the function over to VB and having it be public in a module within my program, and still can't seem to get it to convert.

Is this possible with VB and I'm just missing something?

Thanks,
Chad