In Access Report want to preview and print first two pages only

W

Wayne Viles

The report currently extracts all data from database but I only want the
first two pages of the report to preview, print and change into a Word
Document
 
J

Jeff Boyce

Wayne

Is there something about the data contained on "the first two pages" that
would make it possible to query and get only that data, or are you saying
you only want to use the first two among a much larger set?

The "brute force" approach would be to just send them from Report to Word,
and delete what you don't want.

A more elegant approach (i.e., neat/keen) would be to add code into the
report's Format event that counts pages and quits after 2. Then you could
still send to Word.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Top