Construct Simple Queries

Up a level to ..

Use the Query Builder

 

Share Data Between Drawings and Applications > Access External Databases > Use Queries to Filter Database Information > 

Construct Simple Queries

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

To construct a range query

1. Open the Query Editor as described inTo open the Query Editor.
2. On the Range Query tab, select a field from the Field list.
3. Enter a value in From, or click Look Up Values (From).

   Look Up Values displays a list of all values for the specified field from the database table, so you can select the value that you want. After selecting a value, click OK.

   The query searches for all values greater than or equal to the value that you specify.

4. Enter a value in Through, or click Look Up Values (Through).

   The query searches for all values less than or equal to the value that you specify.

5. If you want to save the query in the current drawing for future use, click Store.
6. Click Execute to execute the query and close the dialog box.