Alphabetic Header in report printing

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
 
M

Marshall Barton

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.


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top