Collect! Credit and Collection Software™

  Page Table of Contents Related 'How To' Tutorials

Select Records

Using the Edit Search Criteria form, you can filter any list to display only the records you want.

Press F6 'Find' or use the Edit menu 'Find' option, or select the Find icon at the top of the screen.

This will display an Edit Search Criteria list of all the fields in the current record. The list contains a 'From' and a 'To' field, which define the search criteria.


Edit Search Criteria

Field

The fields that are available to search for on the record.

Useful Note Indexed fields are displayed with a prefix [#] in front of the name.

Useful Note This form factors in access rights, so if you have a user that does not have access to a field, it will not display.

Top of page.

From

Enter the starting point for a range that you want to search.

Useful Note Indexed fields don't allow for wildcard searches. When you select one of these fields, it will display a list. The value you put into the FROM field must be in the list.

Top of page.

To

Enter the ending point for a range that you want to search.

Useful Note Indexed fields don't allow for wildcard searches. When you select one of these fields, it will display a list. The value you put into the TO field must be in the list.

Top of page.

Range

This field contains a pick list with Include or Exclude. Include means that you want to include the range in your search. Exclude means that you want to exclude the range in your search.

Top of page.

Clear

Press this button to clear the criteria you have set.

Top of page.

Save

Press this button to save the query you have designed. Collect! will prompt you to enter a name and a location. The query will be saved with an *.qry extension.

Top of page.

Load

Press this button to load a previously saved query that you designed. Collect! will allow you to navigate to a folder to select a *.qry file. The query you select will be loaded into the Edit Search Criteria form with all the criteria you saved.

Top of page.

Help

Press this button for help on the Edit Search Criteria form and links to related topics.

Top of page.

Cancel

Select this button to cancel your search and return to the previous screen.

Top of page.

Search

Select this to begin searching the database using the criteria you have set in the Edit Search Criteria form. The results will be displayed when Collect! completes the searching process.

Useful Note It may take a while for Collect! to complete the search if your database is large.

Top of page.

Filter Records For Your Displayed List

  1. Use the Arrows to highlight a field to use for searching.
  2. Fill in the From and To fields to select a range.
  3. Press F8 or choose Search to run the search.

The displayed list will now be limited to those records which match the contents of the 'From' and 'To' fields you filled in.

Useful Note An S will appear in the status bar at the bottom of the screen to indicate 'Search Criteria' is active and the list that you are viewing is filtered.

Note that you can use as many fields for selection as you wish. Some fields are indexed, and very fast searches are possible.

Top of page.

Clear Your Search Criteria

  1. Select Edit from the top menu bar.
  2. Select the Clear Search Criteria option.

The displayed list will now show all records.

Useful Note The S at the bottom of the screen will disappear, indicating that 'Search Criteria' is no longer active.

Top of page.

Exit Without Changing Any Search Criteria

Press Escape or choose Cancel.

Top of page.

Examples

These examples assume you are displaying the Client form. The same principles apply regardless of the particular list you are viewing.

Top of page.

List Clients With

To display all clients starting with 'A'

  1. Use the Arrows to highlight the Name field.
  2. Press Enter twice to move into the From column.
  3. Type the letter 'A' in the 'From' field.
  4. Type an 'A' into the 'To' field.
  5. Press F8.

Top of page.

List Client Range

To list all clients from M to Z

  1. Use the Arrows to highlight the Name field.
  2. Press Enter twice to move into the From column.
  3. Type the letter 'M' in the 'From' field.
  4. Type an 'Z' into the 'To' field.
  5. Press F8.

Top of page.

List Clients With Over 20 Accounts

To list all clients with greater than 20 accounts:

  1. Use the Arrows to highlight the Accounts field.
  2. Press Enter twice to move into the From column.
  3. Type the number 20 into the 'From' field.
  4. Leave the 'To' field blank.
  5. Press F8.

Top of page.

International Currency

Useful Note You may find that using an asterisk [*] in your search will give you better results when searching currency fields for Euro values.

For example:

When searching for a Principal Amount of 1000 Euros, try using *1000 in your search criteria.

Top of page.

Restricting Access Rights

Access to the Edit Search Criteria screen can be completely restricted by assigning rights to the appropriate menu item, that is 301007 EditFind.

By disabling the Find menu, all the alternate access points will be disabled as well. The alternate access points for Edit Search Criteria are F6, CTRL+F, CTRL+G and the Find button in the control bar.

When access is denied, the standard access rights dialog will appear and reveal the ID of the appropriate menu item.

Top of page.

Was this page helpful? Do you have any comments on this document? Can we make it better? If so how may we improve this page.

Please click this link to send us your comments: helpinfo@collect.org