Supress output of a column

[ejhatch]

Hi All,

I have a table called tblcheck which holds the following values:

IT, Yes/No
0001, Yes
0002, No
0003, Yes

I need to set up a query which outputs certain values depending on which of the IT values have been set to Yes. I need to take into account that a user might have all of the values set to Yes. So if I am outputting certain values in the query, I need to have them all set up in case they are used, but would like to suppress the output of any field which is related to a No value.

In the above example I would expect that nothing from 0002 would be output because it is set to No. How can I supress this output based on the Yes/No value. Would I have to do it using VB code?

Thanks,

Evan

 

[neileg]

In query design view add a criterion to your Yes/No column of "Yes".