View Full Version : Using a List of values for a graph


BigJimSlade
03-06-2001, 04:50 AM
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

Pat Hartman
03-06-2001, 09:35 AM
The following article shows how to do this:
Q100131 - ACC How to Create a Parameter In() Statement

You can find it at: http://support.microsoft.com/support/c.asp?FR=0

BigJimSlade
03-06-2001, 10:37 AM
Pat,

As usual, your guidance has shown me the way.

Thanks for your help....

Big Jim