table

[Tammy]

I have a table that i want to pull queries from.

I want to see all the homes with an address on Andalusia. So I want my
query to pull all the homes on Andalusia with all the addresses, so they're
not going to be an exact match; the address field contains both the number
and the street name, for example 1100 Andalusia.

How do I do that?

 

[Ron2006]

I have a table that i want to pull queries from.

I want to see all the homes with an address on Andalusia.  So I want my
query to pull all the homes on Andalusia with all the addresses, so they're
not going to be an exact match; the address field contains both the number
and the street name, for example 1100 Andalusia.

How do I do that?

use a criteria of: Like "*Andalusia*"

 

[Tammy]

thanks Ron - I couldn't udnerstand why it wasn't working.......I wasn't using
the **