Sample Range Query

Suppose you want to find all records for a particular vendor (ID number 9), relating to payments made during the last half of the month of September, 2015. This means that we want to query for a set of records spanning a calendar range from September 16 to September 30, 2015.

You can use a query like this:

  1. Open the A/P Payments form.
  2. On the tool bar, click the Filter button, which retrieves all accounts payable (A/P) payment records.
  3. Press CTRL+Q.
  4. Specify this information in  the A/P Payments Query form, Primary Criteria tab, for the Vendor criteria fields:
    • Select = (Equals) as the operator.
    • In the adjacent list, select the appropriate vendor ID, in this case, 9.
  5. Specify this information in the Additional Criteria tab, in the three query criteria fields:
    • From the first list, select Check Date.
    • From the operator list, select > (Greater than).
    • From the adjacent value drop-down list, specify 09/15/2015.

    Because there is no operator for "greater than or equal to" (>=), we use the day before the first day for which we want records.

  6. Click Add.
  7. From the first  list, select Check Date.
  8. From the operator list, select < (Less than).
  9. From the adjacent value list, specify 10/01/2015.

    Because there is no operator for "less than or equal to" (<=), we use the day after the last day for which we want records.

  10. Click Add.
  11. Click Refresh.

    All records that meet the specified criteria are listed in the Results grid.

  12. To return these records to the parent multiview form (A/P Payments), click OK.
  13. When the system prompts for confirmation, click Yes.
Note:  When you click Yes, all retrieved records are returned to the parent form, replacing whatever was previously displayed in that form. You cannot pick and choose which records to return.