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

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Joseph Hand" Joseph wrote in message
...
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...

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

"Allen Browne" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Joseph Hand" Joseph wrote in message
...
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...