Article ID: 131466
Article Last Modified on 9/25/2003
APPLIES TO
- Microsoft Works 3.0 Standard Edition
- Microsoft Works 3.0a
- Microsoft Works 3.0b
This article was previously published under Q131466
SUMMARY
To find the number of unique entries in a particular field, use a database report containing a sort function.
For example, you can use the sort function to determine how many different cities are in an address database or to find out how many distinct parts exist in an inventory database.
MORE INFORMATION
To find the number of different entries in a particular field, do the following:
- On the Tools menu, click Create New Report.
- Do not select any fields in the report; click OK twice to display the report definition screen.
- On the Edit menu, click Select All.
- On the Insert menu, click Delete Row/Column.
- On the Tools menu, click Sort Records.
- In the "1st Field" box, select the field you want to count the unique entries of.
- Put a check in the Break G box and click OK. Note that a new row, titled Summ <field name>, appears in the report.
- In the first cell of the Summ <field name> row, type an asterisk.
- On the File menu, click Print Preview.
- To find the number of unique entries in a database, simply count the number of asterisks displayed.
For more information about this topic see the following references in the "Microsoft Works User's Guide:"
- Understanding the Report Definition, page 395
- Sorting and Grouping Field Entries, page 425
Additional query words: kbhowto w_works single instance instances match case filter double multiple common individual singular only
Keywords: kbhowto KB131466
