SQL Problem

[mitchem1]

I have a table that has the following columns:

UserName
BCM
CSI
CUINQ
DMI
ESI

The last 5 columns are Yes/No columns which represent IBM accounts that the user may or may not belong to. How would the SQL look if I wanted to return every user that has at least one Yes in any of the IBM account columns?
Thank you.

 

[Mile-O]

WHERE ((BCM = True) OR (CSI = True) etc.)

 

[mitchem1]

Thanks.
After re-reading, I realize I didn't really ask what I was looking for. I've got the SQL working where it returns any user with any account checked Yes. What I cannot figure out how to do is tie this query to a form where the user checks whatever they want. For example, if BCM, DSI, and ESI are checked, the query would return any user where any one or more of those accounts = yes.
Thank you.