Currently, I've got:
TempVars.Add "tempYear", "Like "" * """
However, the query that this gets applied to returns with no results.
Hi Casey,
Now your TempVar has the VALUE: "Like "" * """, and it is understandable that you get no resuls.
In your sql-string you need somethimg like:
" ... WHERE MyField Like ""*" & Tempvar & "*"""
or " ... WHERE MyField Like '*" & Tempvar & "*'"
Imb.