Wildcards?

[Guest]

I want to create a query that lets users search for an item in a column.

I know for input you put Like [Enter Search Here]
and I know for wild cards you use the * key

However, I am having a trouble putting them together. For example if a user
wants to search the notes function.

Thanks!

 

[kingston via AccessMonster.com]

To create a parameter query with wildcards, do something along these lines:

Like "*" & [Parameter1] & "*" & [Parameter2] & "*"

I want to create a query that lets users search for an item in a column.

I know for input you put Like [Enter Search Here]
and I know for wild cards you use the * key

However, I am having a trouble putting them together. For example if a user
wants to search the notes function.

Thanks!

 

[Guest]

Debug.Print StrConv("HAPPY EASTER",3) returns Happy Easter. 3 = vbProperCase.

Debug.Print StrConv("HAPPY EASTER",2) returns happy easter. 2 = vbLowerCase.

Debug.Print LCase("HAPPY EASTER") returns happy easter.

Debug.Print Left(UCase("HAPPY EASTER"),1) & Mid(LCase("HAPPY EASTER"),2)
returns Happy easter.

 

[Guest]

Thanks, Works Great!

To create a parameter query with wildcards, do something along these lines:

Like "*" & [Parameter1] & "*" & [Parameter2] & "*"

I want to create a query that lets users search for an item in a column.

I know for input you put Like [Enter Search Here]
and I know for wild cards you use the * key

However, I am having a trouble putting them together. For example if a user
wants to search the notes function.

Thanks!

 

[Guest]

Whoops! That was what I hope is the right answer for another question.

Sorry about that.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Debug.Print StrConv("HAPPY EASTER",3) returns Happy Easter. 3 = vbProperCase.

Debug.Print StrConv("HAPPY EASTER",2) returns happy easter. 2 = vbLowerCase.

Debug.Print LCase("HAPPY EASTER") returns happy easter.

Debug.Print Left(UCase("HAPPY EASTER"),1) & Mid(LCase("HAPPY EASTER"),2)
returns Happy easter.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I want to create a query that lets users search for an item in a column.

I know for input you put Like [Enter Search Here]
and I know for wild cards you use the * key

However, I am having a trouble putting them together. For example if a user
wants to search the notes function.

Thanks!