Parameter Query

[SueM]

Hi,

I have created a parameter query which works successfully
provided the user enters the name of the item to find 100%
the same as it appears in the table, regardless of whethr
it is entered in upper or lowercase.

What I would like it to be able to do is to find anything
that contains the word the user enters as the parameter.

Can this be done and if so how?

To get the parameter box to appear I have used the
following in the Criteria of a field called productname
within the query[Type the Product Name:]

Any ideas greatly appreciated!

Cheers

Sue

 

[Chris Large]

Try this as the Criteria:-

like "*" & [Type the Product Name:] & "*"

hth

Chris

 

[SueM]

Thank you!

-----Original Message-----
Try this as the Criteria:-

like "*" & [Type the Product Name:] & "*"

hth

Chris

-----Original Message-----
Hi,

I have created a parameter query which works successfully
provided the user enters the name of the item to find 100%
the same as it appears in the table, regardless of whethr
it is entered in upper or lowercase.

What I would like it to be able to do is to find anything
that contains the word the user enters as the parameter.

Can this be done and if so how?

To get the parameter box to appear I have used the
following in the Criteria of a field called productname
within the query[Type the Product Name:]

Any ideas greatly appreciated!

Cheers

Sue


.

.