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?
John Vinson said: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 pageGeeJay said: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 said: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
John W. Vinson said: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?