create a calculated field in SQL

[Guest]

I have wrote the code to create a query

strSQL = "SELECT [table1].field1 ....

inside the SQL statment I want to create a field that will
be calculated from a function

Thank you in advance

 

[Marshall Barton]

I have wrote the code to create a query

strSQL = "SELECT [table1].field1 ....

inside the SQL statment I want to create a field that will
be calculated from a function

strSQL = "SELECT [table1].field1, " _
& "func(table1.field2) AS calcname, " _
& " . . .

If you're using a function you created in a standard module,
make sure the it is declared Public.