query with criteria and no results

[macattack03]

I'm very new to access and don't understand what I'm doing wrong I have created a table with several fields of information from this table I have created a query to only find the information I need. Here is an example of what I'm having problems with



Query fields Customer #, First Name, Last Name, Street, City

I enter in the name of the street under criteria Magee and I find no results however i know that in my table there are two customers with magee for an address
does it matter if the address has like for example 401 Magee and I'm only searching for just the name of the street

Please help in any way you can thanks

[ItsMe]

How and what are you using to start your search? Are you using Access' intrinsic search function?

[macattack03]

no its what I put in the criteria area and then click view for the query no search not sure if i confused you or what

[ItsMe]

In the criteria field within your query, you can place the following

Like "*Magee*"

This criteria includes two wildcards. One before the literal text and one after the text. If the text "Magee" apears anywhere within the field, in the beginning, middle, or the end, the record will return.

Like "Magee*" - this would require that the field begins with Magee. So, 1234 Magee street would not return.