Excell Functions in an SQL query

Ola,

Is it possible to use the Excell Yield function in an Access SQL statement?
LVL 2
DaFouAsked:
Who is Participating?
 
Jokra_the_BarbarianConnect With a Mentor Commented:
If you are working within Access queries and Access SQL (not SQL Server T-SQL), you could create a custom public function and call it within your query. Eg:

Public Function myFunc(val1 as double) as double
  dim x as integer, z as integer
  x=1
  z=3
  myFunc = ((x*z)/z)+val1
End Function

Your query:

Select fld1, fld2, myFunc(fld3) as newFld
From tbl1

Hope this gives you some ideas. If you are working with SQL Server T-SQL, you can create your custom functions in SQL Server just the same.
0
 
dannywarehamCommented:
Yield? I'm not aware of that.
Short answer would be "no".

However, you can emulate teh function if you have it's formula...
0
 
DaFouAuthor Commented:
I have the formula.
Lets imgine the formula is something like this
((x*z)/z)+x2
How can I emulate it?

Be ware though It has to be working in aceess 97 aswell as in access 2003
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.