Alphabetising a report

[Grammie]

I have a report I must produce twice a month of people in a database
and I need to separate it by alphabet...meaning the 1st page would be
"A" with all the people with last names that start with A in that
section.

There cannot be two Alpha sections on a page because I have to put
this in a book with Alpha tabs.

What I've done previously is make queries for each alphabet and then
print each up in a separate report. I know there must be some way to
do it in one report.

Help.

Blessings,
Grammie

[fredg]

On 18 Nov 2004 17:17:08 -0800, Grammie wrote:

I have a report I must produce twice a month of people in a database
and I need to separate it by alphabet...meaning the 1st page would be
"A" with all the people with last names that start with A in that
section.

There cannot be two Alpha sections on a page because I have to put
this in a book with Alpha tabs.

What I've done previously is make queries for each alphabet and then
print each up in a separate report. I know there must be some way to
do it in one report.

Help.

Blessings,
Grammie

In Report Design View, click on View + Sorting and Grouping
Group the report on [LastName], sort Ascending.
Set Group Header to Yes (or Group on =Left([LastName],1) if you wish
all the "A's" together).

If you wish just one Group per page, set the Group Header ForceNewPage
property to Before Section. It's located on the group header property
sheet's format tab.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Bob Quintal]

bm****@yahoo.com (Grammie) wrote in
news:ae**************************@posting.google.c om:

I have a report I must produce twice a month of people in a
database and I need to separate it by alphabet...meaning the
1st page would be "A" with all the people with last names that
start with A in that section.

There cannot be two Alpha sections on a page because I have to
put this in a book with Alpha tabs.

What I've done previously is make queries for each alphabet
and then print each up in a separate report. I know there
must be some way to do it in one report.

Help.

Blessings,
Grammie

In your report, select the grouping and sorting option and tell
the report to group on the name field. Set the Group On to
'prefix characters', the group interval to '1'. Set Group Footer
to 'yes'. ADD THE SAME FIELD AGAIN and tell it to sort on each
value.

In the group footer properties, set Force new page to 'after'.
..
--
Bob Quintal

PA is y I've altered my email address.