Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

query if any value = x

query if any value = x

query if any value = x

So I am having brain fade or something and need some help.

I have a access database and one of the tables has many fields that are equal to either pass or fail. I need a query that will look at the table and if any field equals "Fail" it will populate the entire record.....I tried putting "Fail" as the criteria for each field but that did not work......thanks in advance for any help

RE: query if any value = x

I'll leave to others to discuss design issues. To answer your question, if you are using the query grid, you need to set up the fail as an OR criteria. Sounds like you may have set up as AND. To do an OR on the grid, you would need to diagonal the word "Fail". Something like below. Hopefully, example will render ok on viewing.

Field1   Field2   Field3

RE: query if any value = x

Regarding sxschech's "design issues" comment, I would suggest you evaluate your table structure. It seems to be unnormalized and I expect column/field names actually contain data values. I could be wrong and would be willing to discuss this further but perhaps forum700: Microsoft: Access Tables and Relationships is a better place to post questions.

Hook'D on Access
MS Access MVP 2001-2016

RE: query if any value = x

Thanks sxschech that worked perfectly.......

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close