Querying multiple fields in a Table

[Crackers]

I have a Table [Players], that contains the following fields -
Player....Club....U10I....U10B....U10R.....U10T

The U10* fields are all Yes/No.
Some Players have a Yes in more than one U10* field.

My question is, how do I perform a query that will show Players that have a 'Yes' in any one or more fields, hence not showing those Players that have a No in all fields?
There are a total of 6,000 names in the Database.

An example of the outcome I am looking for would be -

Bill - Melbourne - Yes - No - No - No
Jack - Sydney - No - Yes - Yes - No

I hope I have explained it clearly enough.
Any advice on this subject would be greatly appreciated.

Thank-you.

 

[Rich]

A crosstab query should give you the output you require

 

[raskew]

Boolean fields (True/False, Yes/No) have the value of
True = -1
False = 0

So, by creating a query that sums the values of all the
U10.. fields, any record where the sum <> 0 would have
at least one Yes field. For example:

"SELECT Player, Club, U10I, U10B, U10R, U10T, [U10I]+[U10B]+[U10R]+[U10T] AS Tot" _
& " FROM Players" _
& " WHERE ((([U10I]+[U10B]+[U10R]+[U10T])<>0));"