Alphabet break in report

[amccook]

I have created a report from a query I pulled. On the report, I want it to break after each alphabet letter and pickup the next letter on a new page (putting report in binder with alphabet dividers). How do I do this?

[weekend00]

add a group for the field with alphabet, check to show group header,

in the property of this header, select "before & after" for Force new Page.

Please let me know if more details of the steps are required.

[amccook]

Yes please. I am very new to working in access. I uploaded a pic of my report in design view.
Thank You!!

[weekend00]

I assume the field name is AtoZ which contents the alphabet.

right click on blank area of the report (grey area, not white area with dots), menu shows
select "Sorting and Grouping", window pops up
select AtoZ in "Field/Expression" column;
select yes to "Group Header"
select yes to "Group footer"
close the small window, you will find "AtoZ header" and "AtoZ footer" section added
right click on "AtoZ header", select property
go to "Format" page,
select "before & after" on "Force New Page"

run you report

[amccook]

My field name is LName (I'm sorting alphabetically by the last name). I did what you said and the alphabet is still running over (There are B names on the A page). I'd like for the new letter to start on a new page. Any other suggestions?

[weekend00]

Sorry I can not help further.
Did you try to set Force New Page to "before section" or "after section"?

[amccook]

I tried all of them and ran the report. Still no seperating between the alphabet letters.

[weekend00]

no more idea.

[Rawb]

What you'll want to do is build a query that you run the Report off of, not run the report straight off your Table.

Make a new Query and include all the fields you want to show up in your report. Then make a new field by typing in the following:

Then, in your Report, group by the AtoZ field and set it to break on each value.