BigJimSlade
Registered User.
- Local time
- Today, 18:25
- Joined
- Oct 11, 2000
- Messages
- 173
Hi, Big Jim here....
I am using a function in the Where clause when creating a graph: WHERE column IN (Function)
The function is set = to a list of values contained in a string, generated on my form.
My question is how to set up the Function so that it will properly populate my graph. Usually, I would say: WHERE column IN ('value1', 'value2', 'value3'). I think I set my string up just like this, but to no avail. However, all the function has to return with a single value to make the graph work is value1 with no quotation marks.
Any ideas on how to get the list of values into my WHERE clause?
Thanks in advance....Big Jim
I am using a function in the Where clause when creating a graph: WHERE column IN (Function)
The function is set = to a list of values contained in a string, generated on my form.
My question is how to set up the Function so that it will properly populate my graph. Usually, I would say: WHERE column IN ('value1', 'value2', 'value3'). I think I set my string up just like this, but to no avail. However, all the function has to return with a single value to make the graph work is value1 with no quotation marks.
Any ideas on how to get the list of values into my WHERE clause?
Thanks in advance....Big Jim