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.

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

regards
FSt1



"Sum Limit and marking" wrote:

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.

"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" wrote:

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

regards
FSt1



"Sum Limit and marking" wrote:

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.