Aristotle Support

Relational Operator

Article ID: 744
Last updated: 07 Mar, 2010

Date and Numerical fields will require you to enter a number in the Value box so that the database can compare the contents of the field to what you have entered.  Then select from the following list of Relationships to describe how your results should compare to your Value entry:

 

Exactly Matches

Does Not Exactly Match

Is Greater Than

Is Equal To Or Greater Than

Is Less Than

Is Equal To or Less Than

 

Text fields will require you to enter a text string in the Value box so that the database can determine the relationship of the contents of that field in each record of the database to your entered Value string.  Then select a Relationship that describes the relationship you would like your results to have.

 

Contains

Does Not Contain

Starts With

Ends With

Exactly Matches

Does Not Exactly Match

Is Greater Than

Is Equal To Or Greater Than

Is Less Than

Is Equal To or Less Than

 

Logical fields will have two options for Relationship: "is True" and "is False." The Value box is not used.

 

List-based fields will have a predefined set of available Relationship.  The Value box is not used.

 

Relationship describe the relationship you are seeking between the data in your selected field and your ideal results.  The contents of the Relationship menu will vary based on the Field selected.  For example, if you are looking for all records whose birthdates are later than 1/1/1980, then your relational operator will be is greater than or equal to and you will enter 1/1/1980 in the Value box.  

 

Additional information on using the criteria can be found in the sections below:

Sub-Queries

This article was:   Helpful | Not helpful Report an issue


Article ID: 744
Last updated: 07 Mar, 2010
Revision: 1
Views: 363
Prev     Next
Query Join       Example Sub-Query