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????

On Thu, 11 May 2006 16:09:03 -0700, Mr. Pool & Mrs. Patio <Mr. Pool &
Mrs. (E-Mail Removed)> wrote:

>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????

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]