Related Information Examples & 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.

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

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.

tip.gif 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.

tip.gif 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.

tip.gif 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

tip.gif 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.

See Also

- New User Basics
- How To Search For Records

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