Automate printing of access reports

[jgsketch]

I am a noob when it comes to customizing reports in access. My current setup consists of two databases in SQL and is accessed through access. I run several reports every morning and would like to automate these. These reports pull new customers and deleted customers for the month. Unfortunatly the admins want the reports from the start of the month to current date instead of just daily reports. So every time I run the report, I have to enter the date values, and then print the results. I would love to automate this to automatically enter the date range from the 1st to todays date, and then print out the reports. Is this even possible or do I need something like Crystal Reports for this? Thanks

Jeremy

 

[wardster]

It is certainly something that can be automated - i have attached a little calendar form which shows how to select dates based on the calendar control. have a look through - point your parameters to the textboxes for the dates (ie CurrentDate and MonthStart) then a button to print the report... shouldnt take too much effort.

Hope this helps a little

Ian