query criteria with wildcard

[d.p.]

I've searched around about this issue I'm having, but it's not been too
successful.
My problem is this:
I have a query where a user is prompted for the criteria e.g. [Enter info:],
but that info can get complicated and long, and as we all know, the criteria
has to be exactly as it is in the source table (except for letter case) in
order to get the results you want. Is there a way for the user to enter a
section of the wanted results, either like "abcd*" or "*cdef" or even
"*cde*" and it gives all the records that have the entered string somewhere
in the field of each record.
I hope I'm making sense. Thanks for the help.

[fredg]

On Mon, 26 Jul 2004 23:10:01 +0100, d.p. wrote:

I've searched around about this issue I'm having, but it's not been too
successful.
My problem is this:
I have a query where a user is prompted for the criteria e.g. [Enter info:],
but that info can get complicated and long, and as we all know, the criteria
has to be exactly as it is in the source table (except for letter case) in
order to get the results you want. Is there a way for the user to enter a
section of the wanted results, either like "abcd*" or "*cdef" or even
"*cde*" and it gives all the records that have the entered string somewhere
in the field of each record.
I hope I'm making sense. Thanks for the help.

Use Like.

To return records with the word anywhere in the field:
Like "*" & [Enter info] & "*"

To return records with the word at the beginning of the field:
Like "*" & [Enter info]

To return records with the word at the end of the field:
Like [Enter info] & "*"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[d.p.]

excellent! such simple things...and I go blank!
thanks so much!
"fredg" <fg******@example.invalid> wrote in message
news:19*****************************@40tude.net...

On Mon, 26 Jul 2004 23:10:01 +0100, d.p. wrote:

I've searched around about this issue I'm having, but it's not been too
successful.
My problem is this:
I have a query where a user is prompted for the criteria e.g. [Enter info:], but that info can get complicated and long, and as we all know, the criteria has to be exactly as it is in the source table (except for letter case) in order to get the results you want. Is there a way for the user to enter a section of the wanted results, either like "abcd*" or "*cdef" or even
"*cde*" and it gives all the records that have the entered string somewhere in the field of each record.
I hope I'm making sense. Thanks for the help.

Use Like.

To return records with the word anywhere in the field:
Like "*" & [Enter info] & "*"

To return records with the word at the beginning of the field:
Like "*" & [Enter info]

To return records with the word at the end of the field:
Like [Enter info] & "*"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.