By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,531 Members | 2,219 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,531 IT Pros & Developers. It's quick & easy.

MS Access 2003 - automatically create reports/subreports based on criteria

P: n/a
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

Feb 1 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.