Microsoft KB Archive/95313

{| = How to Group Data by Yearly Quarters =
 * width="100%"|

ID: Q95313

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
 * Microsoft FoxPro for Windows, versions 2.5 and 2.5a

SUMMARY
You can create a report where records are grouped by yearly quarters by using a single data grouping expression.

MORE INFORMATION
To create such a group:

1. The database must be indexed on the appropriate date field

(represented in the expressions below by ). 2. Each quarter can be numbered with the expression: INT((MONTH-1)/3) + 1

Quarter numbers change every three months. Subtracting 1 from the month number makes the first month of each quarter a new multiple of 3: Jan.= 0, Apr.= 3, Jul.= 6, Oct.= 9.

The month numbers are then divided by 3 and the returned integer value is 0 for the first three months, 1 for the next three months, and so on. The correct quarter number is then found by adding 1 to  the integer value. 3. Create a group band based on this expression: STR(YEAR)+STR(INT((MONTH-1)/3)) Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a KBCategory: kbprg KBSubcategory: FxprgGeneral
 * }