Query if any of multiple fields are "true" 1

[mrgrogro]

I have 12 items on a form. They are all check boxes. Any time one of them is checked it indicates an inspection has taken place and there is a problem. How do I set up my query to evaluate if any of the 12 items is checked and place it on my report? I only want to report the items that are checked. I've tried a couple of options but it seems I can only evaluate up to nine of the options at a time. Does this seem right? I'm probably not asking the questions correctly. I rarely query anything. A little guidance would be appreciated. I'm using Access 97 if that makes a difference.

By the way, Happy Thanksgiving!
Thanks in advance

 

[dhookom]

Your table is not normalized. You should consider changing your table structure to one where each item inspection creates its own record. Then your query is very simple.

If you can't change your structure, you can use a union query to normalize the table and then query your union query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mrgrogro]

Thanks Duane. I really appreciate the response. I'll get a little help at work on Monday with the Union Query first. If that doesn't work, I'll write this up to a valuable lesson learned and go to the table change.

Have a great one!
Kevin