Issue with Query Criteria

[PaigeWeber]

I've recently created a new database and imported several tables, and I'm having issue with one of my queries.

I have a query that houses information such as quote numbers, type of quote, state, region, etc. My end goal is to set a criteria within my query to filter on a market. In this example, we will use Arizona.


I follow these steps:

- Open query
- Go to design view
- Type "ARIZONA" in the criteria row under 'market'
- After running the query, I end up with a list of Arizona quotes and 5 random quotes in Wyoming and Northern OH
- Random other lines will also show up in my query that were previously filtered out with a set criteria on the project field

I've performed similar tests on other queries in the same database, but on different data, and sometimes the "Text Here" in the criteria row works, and sometimes it doesn't.. I'm at a loss!

 

[stumac]

Can you post the SQL of your query?

 

[Marbles]

Have you got all your Criteria on the same line.