Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Page Break based on one character.
- Thread starter MBNelson
- Start date
If the report is based on a query, just add a column to the query, labeled BreakCharacter (for lack of a better name), and use the mid function to select only the first character of the field in question. If your report is based on a table, you'll have to create a query that selects everything and then add the aforementioned column. Either way you can then break on this new column in your report.
tlbroadbent
MIS
If you are creating an Access report, look at the Sorting and Grouping options.
1) Add your column to the Field/Expression list.
2) Select Group On: Prefix Characters.
3) Type 1 in Group Interval to indicate one character.
4) In the Group Header properties, choose Force New Page: Before Section. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Thread starter
- #4
- Status
Similar threads
- Question
- Locked
- Question