Not show record if false

[nigel brown]

Hi

I have a query, the fields are in this format:

01 is yes/no
01 Estimate complete date
01 Complete date
02 is yes/no
02 Estimate complete date
02 Complete date

This format goes up to 40.

I am asking if 01 yes/no, is false then do not return the field when the query is run.

In theory the 01 yes/no, 01 estimate and 01 complete would not be in the results if the answer is false to the first field.

Any takers guyus, and girls?

Thanks in advance for any help given.

Regards

Nigel
VBA virgin

 

[Adam Caramon]

First off, I suspect your database is not normalized. That's going to add a whole lot of headaches.

When you say "I am asking if 01 yes/no, is false then do not return the field when the query is run." Do you mean that if your Yes/No field is false you don't want the query to return the record?

If so, simply add into the criteria line of that particular field "True". This means the query will only show you the records where that particular Yes/No field has a value of true.

However, if you try to use this method on 40 yes/no fields you're going to quickly get yourself into an unmanagable situation.