Address Book - New Page for New Letter of the Alphabet

I am wanting to print out my Address Book and would like to force a new page
for each change in the alphabet. Is there a simple way of doing this,
pleaser?
--
GeeJay

On Fri, 2 Dec 2005 16:31:03 -0800, GeeJay
wrote:

I am wanting to print out my Address Book and would like to force a new page
for each change in the alphabet. Is there a simple way of doing this,
pleaser?

Are you talking about the Address Book in Outlook? Or in some
(pre-built) Microsoft Access application? This newsgroup is for
Access; if so, you can create a Report grouping by Left([LastName], 1)
with a page break on the group header... if in Outlook, I'd suggest
you post the question in an Outlook newsgroup.

John W. Vinson[MVP]

Sorry I didn't express myself very well. The Address Book referred to was
actually a Names and Addresses database which I have designed in Access - I
like to dabble! Anyway, thanks for the information, I have now got it
working.
--
GeeJay


"John Vinson" wrote:

On Fri, 2 Dec 2005 16:31:03 -0800, GeeJay
wrote:

I am wanting to print out my Address Book and would like to force a new page
for each change in the alphabet. Is there a simple way of doing this,
pleaser?

Are you talking about the Address Book in Outlook? Or in some
(pre-built) Microsoft Access application? This newsgroup is for
Access; if so, you can create a Report grouping by Left([LastName], 1)
with a page break on the group header... if in Outlook, I'd suggest
you post the question in an Outlook newsgroup.

John W. Vinson[MVP]

"GeeJay" wrote:

Sorry I didn't express myself very well. The Address Book referred to was
actually a Names and Addresses database which I have designed in Access - I
like to dabble! Anyway, thanks for the information, I have now got it
working.
--
GeeJay


"John Vinson" wrote:

On Fri, 2 Dec 2005 16:31:03 -0800, GeeJay
wrote:

I am wanting to print out my Address Book and would like to force a new page
for each change in the alphabet. Is there a simple way of doing this,
pleaser?

Are you talking about the Address Book in Outlook? Or in some
(pre-built) Microsoft Access application? This newsgroup is for
Access; if so, you can create a Report grouping by Left([LastName], 1)
with a page break on the group header... if in Outlook, I'd suggest
you post the question in an Outlook newsgroup.

John W. Vinson[MVP]
I need simple instructions to print an address book that starts a new page
every time there is a change in the alphabet for the last name. I am using
Access 2003. I don't understand the response above. Thanks. Bill

On Wed, 28 Feb 2007 18:30:00 -0800, Linencrane
wrote:

I need simple instructions to print an address book that starts a new page
every time there is a change in the alphabet for the last name. I am using
Access 2003. I don't understand the response above. Thanks. Bill

Create a Query based on the table of names and addresses. In that
query, in a vacant Field cell, type

Initial: Left([Lastname], 1)

using your last name field; this field will contain A for Ambrose, C
for Crane, Z for Zymbrowski.

Create a Report based on this query. View the Report's Sorting and
Grouping dialog. Group By this field Initial, sorted ascending; make
sure that the group Footer is available. In the Footer's properties
select Force New Page.

John W. Vinson [MVP]

Appreciate your help very much. The query produced a Last Name Header.
ThisI inserts the alpha letter in the body of the report. However, I even
though the group footer is designated as "yes", the printed report will not
skip pages when a new initial in the lastname appears. I think the problem
is that I don't understand the instruction: "Group By this field initial."
Under the Sorting and Grouping option, the left column is LastName under
Field/Expression. Am I supposed to type something different in this column?
Thanks again. Bill


"John W. Vinson" wrote:

On Wed, 28 Feb 2007 18:30:00 -0800, Linencrane
wrote:

I need simple instructions to print an address book that starts a new page
every time there is a change in the alphabet for the last name. I am using
Access 2003. I don't understand the response above. Thanks. Bill

Create a Query based on the table of names and addresses. In that
query, in a vacant Field cell, type

Initial: Left([Lastname], 1)

using your last name field; this field will contain A for Ambrose, C
for Crane, Z for Zymbrowski.

Create a Report based on this query. View the Report's Sorting and
Grouping dialog. Group By this field Initial, sorted ascending; make
sure that the group Footer is available. In the Footer's properties
select Force New Page.

John W. Vinson [MVP]

On Thu, 1 Mar 2007 09:51:41 -0800, Linencrane
wrote:

Appreciate your help very much. The query produced a Last Name Header.
ThisI inserts the alpha letter in the body of the report. However, I even
though the group footer is designated as "yes", the printed report will not
skip pages when a new initial in the lastname appears. I think the problem
is that I don't understand the instruction: "Group By this field initial."
Under the Sorting and Grouping option, the left column is LastName under
Field/Expression. Am I supposed to type something different in this column?

Yes.

The name of the calculated Initial field.

John W. Vinson [MVP]