Hi again folks,
Having trouble with a query I'm trying to open. I have 2 parameters in my query, date and treatment number. The problem is that i'm trying to say "any treatment number with a specific date" from code and cannot figure it out. I don't want to mess with my SQL string, what I'm doing right now is the following:
set qd = db.querydefs("queryname")
qd.parameters("[date]") = date
qd.parameters("[treatmentnum]") = "*"
set rs = qd.openrecordset
the problem is the * doesn't produce wildcard results, I need to figure out how i can enter a wildcard character for this value from code in this fashion.
Thanks in advance,
James
Having trouble with a query I'm trying to open. I have 2 parameters in my query, date and treatment number. The problem is that i'm trying to say "any treatment number with a specific date" from code and cannot figure it out. I don't want to mess with my SQL string, what I'm doing right now is the following:
set qd = db.querydefs("queryname")
qd.parameters("[date]") = date
qd.parameters("[treatmentnum]") = "*"
set rs = qd.openrecordset
the problem is the * doesn't produce wildcard results, I need to figure out how i can enter a wildcard character for this value from code in this fashion.
Thanks in advance,
James