table

  • Thread starter Thread starter Tammy
  • Start date Start date
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?
 
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*"
 

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

Split data in field on character return 0
subtotal calculation 2
Access query 1
Display all latest Entries 2
query numeric values from text 4
Display query results only if field is not null 3
Three fields conditionally based on other fields 6
query excluding listings from table 2

Back
Top