Query - Value Entry

This dialog is the last step and is used to collect the value component of the query. This value will be compared (via the operator) to the field in your Product or Vendor records. In essence the value describes the trait the field should have (or not have).

When the value entry has been completed simply press the Next button continue.

Case Sensitivity and Absolute Power

Queries offers many useful features to assist the user with their value consideration. Two examples are Case Sensitivity and Absolute Value. Case sensitivity may be invoked if the selected field is a string while absolute values may be compared when the field is numeric.

Types of Values

•Constant Value

This option allows the user to type the value directly into Queries. As illustrated above, this is the default option and would normally be used with most queries.

The appearance of an ellipses button adjacent to the value entry field indicates a lookup to assist with selecting a value for this entry such as a calendar for date entries.

When the field being queried is a date field the ellipses will call the built-in drop-down calendar.

Page url: http://www.encouragersoftware.com/eclrpthelp/index.html?queries_-_value_entry.htm