Generate a report that adds Letters to group by in the report inc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a way to have a report include a group header (i.e. A.
apearing above all of the content that begins with the letter A). Do I need
to add a column to the table and put the Letter in it that I want to group by
or is there some way to generate this? this table has 14000 rows... it would
be a ton of work to update each row...
 
I take it you want a break on the report before each new letter of the
alphabet?

Open the report in design view.

Open the Sorting And Grouping dialog (View menu.)

Enter the name of the field that has the data (e.g. Surname.)

In the lower pane of the dialog, set these properties:
Group Header Yes
Group On Prefix Characters
Group Interval 1
 
That turned out to be the missing piece... I also added a text box to the
group header with "=Left([Title],1)" in it and got my "A", "B", etc...
headers...

Thanks so much Allen!

joe
 
You must log in or register to reply here.

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

Similar Threads

Report Group Header 9
Letters Generation Database 4
Access Sorting and grouping using multiple tables 0
Including non related text in a report 4
Expandable list in report? 2
Print Report to PDF by Group _ Name by Group? 1
How to put a BIG capital letter at top of each group in a report 1
Report Columns 1

Back
Top