All,

I have a SQL SELECT statement for retrieving my data, and one of the major item is the filter condition, as follow:

SELECT ................ WHERE mycursor.month IN ("02/99","04/99")

However, I need to allow the user the enter the filter condition that he wants in a textbox with the controlsource of the textbox is set to a memory variable (eg, mMonth).

Example,
The user will type :
"02/99","04/99","06"/99"

to filter the month of Feb99,Apr99 and Jun99 which are separated by commas.

Therefore, I put the statement as WHERE mycursor.month IN (mMonth), but the command treated mMonth as a string.
How should I deal with things like this? Suggestion?

Thanks,
Gan