By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,474 Members | 1,273 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,474 IT Pros & Developers. It's quick & easy.

Alphabetising a report

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.