Alphabetical List?

[Kelly Crossley]

I'm putting together an alphabetical guest list. Sorting the guests names is easy, but what I'd like to do is setup the report so that it creates a line break at each letter. See below. How can I do this?

J

Jacobs, John

Jenkins, Chuck

Jones, Ed

K

Kelly, Peter

Kramer, Ted

[Vaughan]

Read up on summary reports. You need to add a calculation field to your table that pulls out the first letter, this will be the "break" field for the summary report.

The calc field would be Left( Surname ; 1 ).

[Kelly Crossley]

Thanks for the help. I've added the "First Letter" field, but I can't figure out how to make the report appear as I described.

[mr_vodka]

Try this...

subsummary_letter.zip

[Kelly Crossley]

I already figured it out by the time I got this, but thank you very much. BTW, it appears that you can't do a sub-summary report based on a calculated field. Is that correct?

Kelly

[mr_vodka]

I am not sure what you mean. You can use calculation fields as your break field as I had done in the demo.

[Kelly Crossley]

Yeah, you're right. I see what I did wrong. I had the calculation result specified as a number, not text.

While we're on this subject, how do I make sure the calculated field is a capital letter? Thanks for our help.

Kelly

[mr_vodka]

Well you could always wrap the calc with Upper.

Upper ( Left ( Text ); 1 ) )

But you dont really have to do that. You can format the field text itself to display as UPPER.