Multiple word search Parameter Query

[Iram]

Hello.
I am having trouble creating a parameter query that will allow me to search
a field for mulitple words.
I have a field called "Desciption" and I would like to type Password Reset
in the parameter pop-up and have it pull up all records that have "Password
Reset" somewhere in the Description field.
Currently I have:
=[Enter Task Keyword] & [Enter Task Keyword]

How should I re-write this query?

Your help is greatly appreciated.

Iram/mcp

 

[Marco]

Hi,

Try something in the query like:

Alike "%" & [Enter Task Keyword] &"%"

 

[Iram]

This works awesome and I will use it for many other queries, but it only
finds records where the two words (for example Password Reset) are next to
each other.
How would we re-write it so that I could find records where the
"Description" field had two words that I was searching for and that were not
side by side, for example "access printer" in a field that had "Tony needs
access to the color printer"
Does my question make sense? I some times tend to confuse people...


Iram/mcp

For example

Hi,

Try something in the query like:

Alike "%" & [Enter Task Keyword] &"%"

Hello.
I am having trouble creating a parameter query that will allow me to search
a field for mulitple words.
I have a field called "Desciption" and I would like to type Password Reset
in the parameter pop-up and have it pull up all records that have "Password
Reset" somewhere in the Description field.
Currently I have:
=[Enter Task Keyword] & [Enter Task Keyword]

How should I re-write this query?

Your help is greatly appreciated.

Iram/mcp

 

[KARL DEWEY]

Use two rows in the design view grid for the criteria. This way it will pull
the records regardless of the order.

Like "*" & [first] & "*" & [2nd] & "*"
Like "*" & [2nd] & "*" & [first] & "*"

--
KARL DEWEY
Build a little - Test a little

This works awesome and I will use it for many other queries, but it only
finds records where the two words (for example Password Reset) are next to
each other.
How would we re-write it so that I could find records where the
"Description" field had two words that I was searching for and that were not
side by side, for example "access printer" in a field that had "Tony needs
access to the color printer"
Does my question make sense? I some times tend to confuse people...


Iram/mcp

For example

Hi,

Try something in the query like:

Alike "%" & [Enter Task Keyword] &"%"

Hello.
I am having trouble creating a parameter query that will allow me to search
a field for mulitple words.
I have a field called "Desciption" and I would like to type Password Reset
in the parameter pop-up and have it pull up all records that have "Password
Reset" somewhere in the Description field.
Currently I have:
=[Enter Task Keyword] & [Enter Task Keyword]

How should I re-write this query?

Your help is greatly appreciated.

Iram/mcp

 

[Iram]

It worked!
You guys are awesome!!!


iram/mcp

Use two rows in the design view grid for the criteria. This way it will pull
the records regardless of the order.

Like "*" & [first] & "*" & [2nd] & "*"
Like "*" & [2nd] & "*" & [first] & "*"

--
KARL DEWEY
Build a little - Test a little

This works awesome and I will use it for many other queries, but it only
finds records where the two words (for example Password Reset) are next to
each other.
How would we re-write it so that I could find records where the
"Description" field had two words that I was searching for and that were not
side by side, for example "access printer" in a field that had "Tony needs
access to the color printer"
Does my question make sense? I some times tend to confuse people...


Iram/mcp

For example

Hi,

Try something in the query like:

Alike "%" & [Enter Task Keyword] &"%"







:

Hello.
I am having trouble creating a parameter query that will allow me to search
a field for mulitple words.
I have a field called "Desciption" and I would like to type Password Reset
in the parameter pop-up and have it pull up all records that have "Password
Reset" somewhere in the Description field.
Currently I have:
=[Enter Task Keyword] & [Enter Task Keyword]

How should I re-write this query?

Your help is greatly appreciated.

Iram/mcp