Query By Form Help Using MS Access 2010

By alwaysajewell ·
I have a search form that has five fields I can enter criteria in. When I enter Brown in the last name field and Mayor in the office field, I get every person named Brown and every person that ran for mayor. I need to get only those persons named Brown that ran for mayor. I changed the SQL to AND instead of OR, and when I did a search, nothing came up.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

two thoughts

by john.a.wills In reply to Query By Form Help Using ...

1. Maybe no-one named Brown has ever run for Mayor.
2. Maybe you put the AND in the wrong place or the wrong context: carefully check any parentheses in your query, remembering that AND binds tighter than OR.

Collapse -

Reponse To Answer

by alwaysajewell In reply to two thoughts

Thank you for your answer. I will check the parentheses in the query. I know there is one Brown for Mayor that should have come up.

Related Discussions

Related Forums