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 **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Have 4 email addresses Want to auto forward all in one of them 0
Insert name and adress from a list in a word document 1
Dynamic Naming of Form Button 3
Address Format changed after Migration 0
Auto Populate One Pages from spreadsheet 0
query excluding listings from table 2
Setting column width in a table with a macro is not working 0

Top