June 26, 200817 yr 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
June 26, 200817 yr 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 ).
June 26, 200817 yr Author 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.
June 26, 200817 yr Author 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
June 26, 200817 yr I am not sure what you mean. You can use calculation fields as your break field as I had done in the demo.
June 26, 200817 yr Author 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
June 26, 200817 yr 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.
Create an account or sign in to comment