On Jul 9, 10:18*am, Tammy wrote:
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*"