Query Wizard - Components of a Query

Each Query may consist of one or more questions, logically connected with an AND or an OR logical operator to complete a valid "computer" question. Query Wizard must collect three components of information: Field, Operator and Value. Given these three components, Query Wizard will construct a meaningful question.

Field - The Field is generally representative of information contained within roomMaster available to be used in the query. Usually, these are the same as the fields you would see on the screen that the user usually enters data in to. A few examples of fields would be Account Balance, Last Name, CheckIn Date or Zip Code.

Operator - The Operator represents the comparison to be made between the Field and Value. Due to the nature of the value, operator selections for numbers are limited when compared to those for text. For example the most common numeric operators are Greater Than, Less Than or Equal To. The nature of text operators allow for such comparisons as Contains and Begins With.

Value - The Value will be compared (via the operator) to the field in your database. The value entry is the way you wish to describe the subject (field) of the question. In essence the value describes the trait the field should have (or not have).