If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
table
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? |
#2
|
|||
|
|||
table
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*" |
#3
|
|||
|
|||
table
thanks Ron - I couldn't udnerstand why it wasn't working.......I wasn't using
the ** "Ron2006" wrote: 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*" |
Thread Tools | |
Display Modes | |
|
|