Page Breaks

[Marcus]

I need to force a page-break in my report every time the first character of one of my fields advances from A to B, B to C, C to D, etc. I had hoped to achieve this by setting up a hidden (calculated) field containing the first character of the field, group by this hidden field and attach a page-break to the group header.

I thought that =LEFT([surname],1) would do the trick for the calculated field but Access reports an error when I run the report. Has anyone any suggestions?

 

[Carol]

Create a Header to contain the field that you want groupings on. Select this to sort Ascending with Group Header = Yes, Group Footer = No, and Group On = Prefix Characters. For example purposes, I will use CustomerName. In the header, create a text box with the following:

=UCase(Left([CustomerName],1))

This will create a new header for each Letter of the alphabet.

In the properties for the group header under Force New Page - Select Before Section.

That should give you what you want.

Good luck.