query criteria parameters "contains"

  • Thread starter Sum Limit and marking
  • Start date
S

Sum Limit and marking

I've created a query that I want to run from excel but with the criteria I
want to use within the query I am not able to acheive this. The criteria I
want to use is "contains" and I've tried using the [], but it does not work
the same way as if I was using the criteria of "Equals" or "Between". Can
anyone help me?

Thanks.
 
F

FSt1

hi,
not sure what you mean by "contains" but look up the LIKE operator in vb
help. alt+f11>help. if i read you correctly, this may be what you are looking
for.

regards
FSt1
 
S

Sum Limit and marking

"contains" is a criteria that can be selected to filter the data within a
query. Its a selection simliar to "equals", "like", or "between" when adding
a criteria to a query.

In response to your suggestion I tried using like, however, it does not
acheive the same solution as "contains".

Any other suggestions?

Thanks.

FSt1 said:
hi,
not sure what you mean by "contains" but look up the LIKE operator in vb
help. alt+f11>help. if i read you correctly, this may be what you are looking
for.

regards
FSt1



Sum Limit and marking said:
I've created a query that I want to run from excel but with the criteria I
want to use within the query I am not able to acheive this. The criteria I
want to use is "contains" and I've tried using the [], but it does not work
the same way as if I was using the criteria of "Equals" or "Between". Can
anyone help me?

Thanks.
Click to expand...
Click to expand...
 
Top