Possible to use VBA functions (module) in Access SQL?

[jstroup]

Is it possible to use a VBA function (module)in a
FrontPage 2002 SQL query to an Access Database?

Something like:

fp_sQry="SELECT tblOne.ID, fcnConvert([tblOne.Field2]) AS
ConvertedData FROM tblOne"

Where "fcnConvert" is a function stored in a modeule in
the Access database being queried?

When I try this I get a "fucntion not defined" error.

Many Thanks - (e-mail address removed)

 

[jon spivey]

In a word - No. You'd need to do the convertion on your asp page.