FAQ categories: Access | Background | Data | Mapping | SDM | Technical | Tools |

How are AND OR operators used in reports?

When building a report there are a number of parameters that can be set.  The report queries are constructed using a combination of operator functions:

The AND operator displays a record if both the first condition AND the second condition are true.  The AND operator is used when values are set between different options.  For example:

 I want a list of:

 - Area of Interest = National (AND)

 - Facility Type = AGP (AND)

 - Facility Sub Type = 3G Rubber Crumb (AND)

 - Pitch Count => 2 (AND)

 - Small AGP Flag ticked

 This would generate a report output of only small sided 3G APGs facilities with more than 2 pitches located in England.

  

The OR operator displays a record if either the first condition OR the second condition is true.  The OR operator is used when multiple values within a single option.  For example:

 I want a list of:

 - Area of Interest = Kent (AND)

 - Facility Type = Grass Pitches (AND)

 - Ownership = Local Authority (OR) Education (OR) Sports Club

 This would generate a report output of Grass Pitches in Kent that are either owned by the Local Authority sector or the Education sector or Sports Clubs.

 

It should be noted that no results may be generated if certain options are used e.g. for GOLF.  Unlike most facility types Golf has sub types that do not share the same attributes (i.e. Driving ranges do not have the same attributes as par 3 or standard courses).  For example:

 I want a list of:

 - Area of Interest = National (AND)

 - Golf (AND)

 - Bays = >4 (AND)

 - Holes = >4

 This would generate a report output of no results as no single facility has both Bay and Hole attributes.