How to build reports in Access Data Projects
I love reports in access for one simple reason.. they are easy to email pdf or Excel. But I honestly haven’t used access reports in about five years… Ever since I found tight integration between access, sql and email is quite exciting.
Sql server can integrate with email directly… Which is one option.
Or you can email reports via access using one of several methods:
1. Manually run report.. filling out any parameters and then choosing send under the office button on the top left of the screen.
2. Docmd.sendobject allows you to easily automate sending emails.