Automatically Run Report

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I need to run a report every month (or every 30 days)
thats based on a query. The query records have a "Join
Date" field. I'm trying to print reports automatically
every 30 days from the "Join Date"

Can anybody help?
 
Create a calculated field in your query. Name the field something like:
ReportDate:DateAdd("d", 30,[JoinDate]) This will give you a date 30 days
from the join date.

Then in the criteria type: Between [StartDate] and [End Date]. Type in the
date span you want to cover. So if you want to catch all those that joined
in may, you would type 6/1/04 to 6/30/04. Then when June is over, you type
7/1/2004 to 7/31/2004 to catch those who joined in June.

And/or
Create another calculated field that calculates the difference between the
Join Date and the current date.
ThirtyDays: DateDiff("d",[CheckedDate],Date())

This should help you get started. As for running the reports everything 30
days automatically, that is another story and would involve VBA coding.
 
Back
Top