Alphabetic Header in report printing

  • Thread starter Thread starter Bob Robertson
  • Start date Start date
B

Bob Robertson

I have a report which outputs a membership list in alphabetical order.
What I would like to be able to do is at the start of the output list is to
place the letter of the alphabet eg..A and when the list changes to the next
letter in the alphabet to place B the so on until Z.

Can this be done, help would be much appreciated.
Bob
 
Bob said:
I have a report which outputs a membership list in alphabetical order.
What I would like to be able to do is at the start of the output list is to
place the letter of the alphabet eg..A and when the list changes to the next
letter in the alphabet to place B the so on until Z.
Click to expand...


Use the report's Sorting and Grouping window(View menu) to
group on the expression:
=Left(membernamefield, 1)
and specify Yes in the group header property in the bottom
part of the screen. Then add a text box to the group header
section and use the same expression for the text box's
control source.
 
Back
Top