Microsoft KB Archive/28330

Mac Works: Using Total On Field Change in Database

PSS ID Number: Q28330 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0 4.0

MACINTOSH

================================================================ ==

The information in this article applies to:

 == Microsoft Works for the Macintosh, versions 1.x, 2.0, 3.0, and 4.0 == 

= SUMMARY =

In the report mode of the Microsoft Works Database module, you can subtotal a numeric field whenever the contents of another, specified field change as long as the following conditions are met:

  The database is sorted by the field in which the field change is to occur.   In Report View, this specified field must be highlighted.   The appropriate menu item must be selected: Works 1.x: Total On Field Change is selected under the TotalsPage menu. Works 2.0: Take A Sub-Total On Field Change is selected under the TotalsPage menu. Works 3.0: Take A Sub-Total On Field Change is selected under the Totals menu. Works 4.0: From the Format menu, choose Report Layout Groups, select a field to group, then Summary and select a field to summarize, and Show Field Summaries At End Of Each Group.   Exactly the same information is entered in the specified fields. Do not add extra spaces before or after the text in the specified field. Works considers “Bruce Ludwig” and “Bruce Ludwig” to be two different names.   No blank records exist in the database. If there is a blank field between two like fields, Works will subtotal all three separately. 

Additional query words: 1.00 1.10 2.00 3.00 mwksdb 4.00 macworks mwkswp ====================================================================== Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.