e-mailing sections of report

  • Thread starter Thread starter Dallas
  • Start date Start date
D

Dallas

I use access 2000 with xp and would like to know how to e-
mail a report section, ie., one page of a 10 page
report.Currently, if I e-mail the report all 10 pages are
included. Any suggestions would be appreciated.
Dallas
 
Dallas said:
I use access 2000 with xp and would like to know how to e-
mail a report section, ie., one page of a 10 page
report.Currently, if I e-mail the report all 10 pages are
included. Any suggestions would be appreciated.
Click to expand...

You can use the WhereCondition of the DoCmd.OpenReport or an SQL statement
that you pick up in the Report's Open event and use to replace the Report's
RecordSource to limit the output in the entire Repor to what you desire to
e-mail. I know of no way to select a particular page or subset of a report
out of a larger report.

Larry Linson
Microsoft Access MVP
 
Back
Top