I need MS Access to automatically create reports/subreports based on
specific criteria. I am building a database in Access 2003 with
different locations/sites. I have the "sites" table created containing
site info, including an empty field for "date". I also have a report
format already created displaying the site info. I need Access to ask
the user for a date, calculate three additional dates using the entered
date (adding or subtracting days), and create entries in a seperate
"visits" table based on these different dates, linked to the Sites
table with the SiteID as the promary key. These four different dates
relate to different visits to a site. This would create four seperate
entries per site, one for each site visit. I would also like Access to
create four seperate reports based on these entries. Lastly, I need
Access to insert MS Word document files into only one of these reports
for printing, based on date. I know how to insert the Word files into a
record manually, but would like Access to do so automatically for me.
Let me know if this is possible in MS Access 2003. Thanks for any help
you can give me. Please let me know if you need more information from
me.