Create an on/off button beside query criterion, so that criteria can be used/ignored on the fly.

This would streamline the process of querying differen't criteria without having to establish multiple queries for each hypothetical'. Currently, the only way to accomplish the equivalent of this, would be to store criteria in the sort field, so that it does not interfere with the query results, and then pull it into Criteria from the Query Fields drill-down.

Just a simple button would save so much time.

Eg. Querying Males 18 to 25 and females 18 to 25 in some Region in a Past year, each gender separately. This would require the adding and subrtacting of each set of criteria (or movement into and from the sort tab for each set). 'Much more easily dealt with--with an on/off button.

  • Guest
  • May 8 2014
  • Attach files
  • Guest commented
    March 17, 2016 23:37

    Great idea...

  • Guest commented
    March 17, 2016 23:37

    Here is an image I have made as a rough example (i.e. not taking into account SQL technicalities)

    http://i.imgur.com/Io8kNFP.png