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
 
Back
Top