How can I print several Access database records onto one page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have numerous Access database records in one table, which when printed,
would only be about two inches high. I'd like to avoid having Access print
each record on an individual sheet, and therefore would like to have Access
print as many records onto one sheet as possible.

Any suggestions?

Thanks
 
You print data from Access using a REPORT. Go build a report and set it to
print however you'd like.
 
Rick said:
You print data from Access using a REPORT. Go build a report and set it to
print however you'd like.
Click to expand...

Although this is pretty much true, I've sometimes found Access Reports
to be a bit limited in format. You might wish instead to consider using
Microsoft Word to do the formatting, in case the Access Report you
create doesn't do everything you'd like it to do.

Having set up the Query that serves as a data source for your Report,
save your database and, in Word, set up a "Mail Merge" document that
imports the fields you want to display using your new Query as the data
source for Mail Merge. If you want rows & columns, such as for mailing
labels, a Word table (not quite the same thing as an Access Table) might
be suitable, and you can place the merge fields into cells in the table.
(The Mail Merge Wizard can do a lot of this automagically.)

Or, you can use the <<Next Record>> field to put multiple records from
your Access Query onto a single page in some format that you choose,
perhaps laid out differently from the way a Word table would look.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Thanks very much!!!

Vincent Johns said:
Although this is pretty much true, I've sometimes found Access Reports
to be a bit limited in format. You might wish instead to consider using
Microsoft Word to do the formatting, in case the Access Report you
create doesn't do everything you'd like it to do.

Having set up the Query that serves as a data source for your Report,
save your database and, in Word, set up a "Mail Merge" document that
imports the fields you want to display using your new Query as the data
source for Mail Merge. If you want rows & columns, such as for mailing
labels, a Word table (not quite the same thing as an Access Table) might
be suitable, and you can place the merge fields into cells in the table.
(The Mail Merge Wizard can do a lot of this automagically.)

Or, you can use the <<Next Record>> field to put multiple records from
your Access Query onto a single page in some format that you choose,
perhaps laid out differently from the way a Word table would look.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
Click to expand...
 
Back
Top