Help needed

Ok it has been a while since I have done any database work and I am a little rusty. My problem is I have a table in access with some text fields and 20 fields with yes/no check boxes. What I want is a query that will return all rows but only display the fields who’s check boxes have a "yes" value. Any help appreciated.

Thanks

Asylum

try tis ..
open the table in the query,
1st column put the text field , the 2nd column give a name on it and type "checked" in the criteria , uncheck the checkbox in "show"

Unfortunately that does not work. Thanks for the help though. Got any other ideas.

Asylum

OK. I had this problem a bit ago. As i see it you have two situations. Do you want to pull out every text field that has even one box ticked or do you only want the ones that have all ticked. The difference is quite small. Simply open the table in query, add your text field and all the check boxes. In the first case then type yes in the criteria box for the check boxes downwards and horizontally right. If you remember your SQL from rustiness you want to set up a load of OR commands. For the second just type yes in the first criteria row for all the check boxes. Hoe you understand what I mean.