It is often convenient to group records together in meaningful groups.

If the field is an alpha field then the program will automatically group on the first letter of the value.

If the field is a date field then if more than one year is being displayed then the grouping will be years. If less than a year but more than one month then the grouping will be months. Less than a month then the grouping will be days.

Time fields will be grouped into 24 Hour groups.

For numeric fields the programme takes the highest and lowest values and requests you to specify the maximum number of groups.

The programme will work out the best division of values that correspond best to that number of groups.

Here note that PatName is an alpha field so has been divided into groups of the first letter of that field.

Age is a numeric field and has been divided into 10 groups as requested.

Bdate is a date field and has automatically been grouped by year since more than one year is featured.

By selecting the year 1925 the following grouping is displayed:

displaying a grouping by month.

Now select just one month and the following is displayed:

displaying a grouping by day of the month.