Yes/No fields in a query

[itfcjames]

Hi,

I am used to working in Access but not with any SQL or coding so any help geared towards a 'beginner' would be most appreciated.



I have in a query two Yes/No fields which are check boxes. It is a football-related database and one Yes/No field is for whether a player received a yellow card and the other is for whether a player received a red card.

Obviously in some matches neither of the two boxes will be checked, in some matches one of the two boxes will be checked and on rare occasions, both boxes will be checked.

Is there any way I can run the query to only show records where at least one of the boxes is checked, it doesn't matter which one is checked but I don't want the query to return those records where neither box is checked.

Many thanks in advance for any help,

James

[SoftwareMatters]

You just need an OR statement.
So, in your query put -1 in the yellow column's criteria and -1 in the red column's criteria but the 2nd line down.

[itfcjames]

Hi,

Many thanks for your help, its much appreciated