I have a Query in Access 97 which uses some VB functions to derive the value of various fields in the query based on other values in the row. So for example a VB function
is defined so that if z > 10 then the value returned is x+y, otherwise its just x. The query then runs like
The functions are actually more complex than this but it illustrates the point.
I want to be able to report on this query via ODBC using (among other things) Crystal. The problem is that Crystal says that this query has no fields and refuses to let me report on it.
Any ideas ?
Code:
f(x,y,z)
Code:
SELECT f(x,y,z) FROM MYTABLE;
The functions are actually more complex than this but it illustrates the point.
I want to be able to report on this query via ODBC using (among other things) Crystal. The problem is that Crystal says that this query has no fields and refuses to let me report on it.
Any ideas ?