Issue running multiple field query

Escondido

Registered User.
Local time
Today, 09:08
Joined
Oct 16, 2016
Messages
12
I have a query setup as usual, including all the fields I want to see. My goal is to only see people with a specific birth month, birth birth year and state (see attached). The query for birth month and birth year works perfectly and shows everybody in the database, but anytime I add the 2 digit state abbreviation the query still shows every single client.

I'm been trying to figure out why this is happening and how to fix it.

Does anybody have suggestions?
 

Attachments

  • Capture.PNG
    Capture.PNG
    5.7 KB · Views: 102
The state criteria would have to be repeated on every line in design view
 
That worked like a charm. Thanks.
 

Users who are viewing this thread

Back
Top Bottom