can i use wild cards in the pop up screne in a parameter query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im new at using Access 2003 please help
I have a table with all our customer info in it & I need to be able to easly
pull up that info. Currently under last name field i have [Enter Customers
Last Name] in Criteria in Customer Address field I want to be able to only
[enter customer street # to the address] in the criteria field Example: an
address could be 7455 E. Burban St. #56
This is very complicated and could be entered many diff. ways. Ive tried
[Enter customer street # to Address] and entered Like"7455*" and this does
not work.
Can this be done and how Please????
 
Im new at using Access 2003 please help
I have a table with all our customer info in it & I need to be able to easly
pull up that info. Currently under last name field i have [Enter Customers
Last Name] in Criteria in Customer Address field I want to be able to only
[enter customer street # to the address] in the criteria field Example: an
address could be 7455 E. Burban St. #56
This is very complicated and could be entered many diff. ways. Ive tried
[Enter customer street # to Address] and entered Like"7455*" and this does
not work.
Can this be done and how Please????
Click to expand...

Use a criterion such as

LIKE "*" & [Enter customer street #] & "*"

You can't include operators such as LIKE in your typed-in criteria,
just the value to be searched - that's why your criterion didn't work.

John W. Vinson[MVP]
 
Back
Top