To create an advanced database query (indexes, filters, conditions, and command properties)

  1. On Query Builder, define the basic database query.
  2. Add an index to the query. See Adding an index to a query.
  3. Add a filter to the query. See Adding a filter to a query.
  4. Add a condition to the query. See Adding a condition to a database query.
  5. Modify the command properties for the query. See Modifying database query command properties.
  6. Click Execute to test the query.
  7. Save the query.
  8. To make the query available to your VB or other application, select the text of the query and then select Copy from the Edit menu to place your query on the Windows clipboard.