create a calculated field in SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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.
 
Back
Top