This may have been covered in another post so I apologize ahead. What I am trying to do is to store a function call in a table field (identified as text), and then try to run that function in a query. I need to know how to tell the query to run the function, instead of just returning the text of the function.
Example:
Table 1:
Field Name Field Contents
Fields: Product_ID = 68500
Fields: Products_Function = fp([some date from another table], 1)
So when I use the [Products_Function] field in a query it just returns the text contents. I want it to run the function.
Help!!!
MS Access 2003 SP =3
Gina
Example:
Table 1:
Field Name Field Contents
Fields: Product_ID = 68500
Fields: Products_Function = fp([some date from another table], 1)
So when I use the [Products_Function] field in a query it just returns the text contents. I want it to run the function.
Help!!!
MS Access 2003 SP =3
Gina