I have several yes fields but I only want to lists the ones which contains
values
Please explain what you mean.
There's no such thing as a "yes field" - there are Yes/No datatype
fields; and I am not certain what you mean by "want to list the ones
which contain values" - a Yes/No field ALWAYS contains a value which
may be Yes or it may be No.
John W. Vinson[MVP]