Query Showing Only Selected Fields

[jvet4]

I have a database that has contains requirement numbers and tests that they belong to. The field (TestA, TestB...etc) are yes/no data type, generating a sheet that looks like:

Req# TestA TestB TestC TestD
1 yes yes
2 yes yes

I was wondering it there was a way to write a query so that I can enter a Req# and ONLY show the tests that are 'yes' (if I enter 1 as the requirement to look for, it will only show TestA and TestB, no others)

Any help would be appreciated,
Thanks

 

[montrose]

In your query design grid, set your criteria to "Yes" for each test field. Hope that helps.