table

T

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

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?
Click to expand...

use a criteria of: Like "*Andalusia*"
 
T

Tammy

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