Microsoft KB Archive/60985

Works: Cannot Break on First Digit Number in a Database Report

PSS ID Number: Q60985 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbprint

= SUMMARY =

You cannot use the first digit of a number as a break field in a Works database report by checking the “first letter” box. The “first letter” box works only with text fields.

For example, a customer may want to break a sales report by the thousands (all products sold between $1000-$1999, $2000-$2999, etc.). The following example shows how to create a break every time the number in the thousandth place changes:

  Add a field to the database with the following formula: =int(fieldname/1000) This returns a single digit. For example, 3836 returns the number “3”.   Switch to report view, and sort on the new field with a regular break (not a first letter break). This new field does not have to print in the report to be used as a break field. 

For more information about break fields, please see “To Sort a Report and Set Up Breaks” on Page 233 of the “Microsoft Works Reference.”

KBCategory: kbprint KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.