Product Name Figure

Figure 11-13 demonstrates what Access should produce, based on the fact that the header should print with every product name. The way to prevent this is to use a property of the Group called Group On. The Group On property has two settings, which are Each Value and Prefix Characters. The value used in the most recent picture is when Each Value is selected, and as you can see, it does not have the desired effect.

When you set the property to Prefix Characters, you can then specify the number of characters that are to be used in the grouping. In the case of the Index letter example, it makes sense that the value of 1 is used. In Figure 11-14, the Sorting and Grouping box is displayed using these settings.

Figure 11-14

In this example of the Sorting and Grouping dialog box, the Expression is set to use a Group Header and Footer section in the report. The Group On property is set to Prefix Characters and the Group Interval is set to 1.

0 0

Post a comment