Constructs a query that returns all records or objects that fall within a given range of values.
List of Options
The following options are displayed.
- Field
-
Lists the fields from the current database table, from which you can select one to apply to the query.
- From
-
Specifies the first value of the range. The query returns all records or graphical objects that are greater than or equal to this value.
- Look Up Values (From, Through)
-
Returns a list of all values for the specified field from the database table in the Column Values dialog box, from which you can select the value you want.
- Through
-
Specifies the second value of the range. The query returns all records or graphical objects that are less than or equal to this value.
- Indicate Records in Data View
-
Indicates records that match your search criterion in the Data View window.
- Indicate Objects in Drawing
-
Indicates linked objects that match your search criterion in the current drawing.
- Execute
-
Issues the finished query and closes the dialog box.
- Close
-
Closes the dialog box without issuing the query.
- Store
-
Saves the query with the current drawing.
- Options
-
Opens the Data View and Query Options dialog box.