Help Please Creating Address Report for booklet printing

[baz]

I am using Access 2002 for XP.

I have a listing of names, addresses and information under each
address.

I want to create a report, 11 x 8.5 (landscape) so names and sub info
will appear on left side of the page and also on the right side of the
page as this will be folded in half, stapled in the middle and become
a directory for people to use.

I can create a Report where all the info is placed where I want it I
just do not know how to make it go down the list alphabetically and
also break, or if need be paginate, on the variable number of items of
sub information.

Since this will be used as a directory I also need to have the print
out print the facing pages in correct order to all line up when
folded. My desktop publishing does this automatically but I don't know
how to do it in Access.

Here is how it could look:

Name
Address
City
Contact info

Item 1
Item 2
etc.

The "Items" could be none, one, or several.

Please post any responses as email used is bogus to prevent spam.

Thanks for any help in advance

BAZ

 

[Chuck]

I am using Access 2002 for XP.

I have a listing of names, addresses and information under each
address.

I want to create a report, 11 x 8.5 (landscape) so names and sub info
will appear on left side of the page and also on the right side of the
page as this will be folded in half, stapled in the middle and become
a directory for people to use.

I can create a Report where all the info is placed where I want it I
just do not know how to make it go down the list alphabetically and
also break, or if need be paginate, on the variable number of items of
sub information.

Since this will be used as a directory I also need to have the print
out print the facing pages in correct order to all line up when
folded. My desktop publishing does this automatically but I don't know
how to do it in Access.

Here is how it could look:

Name
Address
City
Contact info

Item 1
Item 2
etc.

The "Items" could be none, one, or several.

Please post any responses as email used is bogus to prevent spam.

Thanks for any help in advance

BAZ

from a post by Bob Howard

I finally decided to use a software product called FinePrint
(www.fineprint.com) which acts as a Postscript printer. I give it the
appropriate settings to configure the result as a booklet, and it takes care
of the whole thing.

To perform its magic, it buffers the entire report and then assembles the
result for viewing and eventual printing. If the report (as created by
Access) contains other than an exact multiple of 4 pages, FinePrint will add
from 1 to 3 extra blank pages at the end to yield an exact multiple of 4.

Then it assembles the result (including any extra blank pages), by placing
the first and last pages together on one side of a sheet, the second and
next-to-last pages together on the other side of that sheet, etc. etc.

Finally, on the sheet that forms the exact center of the result, it places
two consecutive pages together (if you open the booklet to here, this is
where you'ld see the staple).

It does a "fine" job (groan)!

It will then (optionally, depending how you define its settings) either
print the result immediately or present it for viewing. If presented for
viewing, you can look it over, change some settings, apply watermarks, etc.
etc., and then send it to one of several printers (or to a PDF).

When defining a physical printer to FinePrint, you tell it whether the
printer has hardware duplexing capabilities (I have a Canon MP780 which
does). If the printer does not have duplexing, then you tell FinePrint how
to achieve a duplexing result (specifically, on what axis the paper needs to
be flipped).

When FinePrint prints on a type of printer that doesn't have hardware
duplexing, it prints the first side and then it issues a message telling you
exactly how to flip the paper and put it back into the input tray --- then
it prints the other side.

FinePrint is downloadable and can be tested for free. Until you
purchase/register it, it applies a "reminder commercial" at the bottom of
the pages, and limits the result to 4 pages. So it can be tested until
you're sure it's the software you want.

I've described just a few of its capabilities --- it has a zillion other
features.

The purchase price is currently $49.95

I didn't bother to purchase it since I don't actually use the Access
software I'm developing. For development purposes, the free option
satisfies my needs. My clients will be purchasing it, however.

Bob.